TEXT() doesn't remove comma

TEXT([_RowNumber] + 30000)) returns "30,444" not "30444" as I would like.

Solved Solved
0 2 111
1 ACCEPTED SOLUTION

Nope. Easiest way is to simply concatenate the number with a blank string:

"" & [number]

 

View solution in original post

2 REPLIES 2

Nope. Easiest way is to simply concatenate the number with a blank string:

"" & [number]

 

Thanks that did it!

Top Labels in this Space