Remove commas from numeric field in report

Question

Hello,

I hope someone can help. I'm trying to remove commas from a numeric field that I'm emailing to a list of individuals using the layout and render reporting tools. I don't see the commas in the workflow, but when I open up the excel spreadsheet I see them. I've tried other suggestions like the replacing comma with blanks, removing commas from localization, and I can't figure out how to do this using the data cleansing tool. Does anyone have any other suggestions?

Thank you

TheMattLeonard · Answer

I'm assuming you are using a table tool before the layout and render? The Table Tool adds commas no matter what, and as far as I know there is no way to turn that off.

To accomplish what you want I think you'll need to unfortunately go against the grain and format your numeric field as text. Look into using the ToString Field.

Deano478 · Answer

hey @JennyRuns24 do you have some sample figures we can experiment with?

I would usually use a formula like this on the data before doing any reporting:

ToNumber(Replace([Numbers], ",", ""))