Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How can I remove thousand separators from nos. that are 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?

I am using CR 11.

Thanks

Former Member
Former Member replied

ToText(10000, 0,"")

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question