How can I cunningly remove thousand separators from nos. converted to text?
Its all in the title.
I have a string formula to concatenate various string fields together which works fine, however I come a little unstuck when adding a number to the end of the string that is 1000 or greater.
I dont wish to see the comma (thousand separator).
I use the Totext formula to convert the number to text
eg Totext (,0) where might be a Year 2008
This would appear as 2,008
I also have audit numbers that could go into the millions and have 2 commas.
Is there an easy way to remove them, or should I build up a string character by character using a loop formula?