Remove commas from numeric field in report

[JennyRuns24]

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

[Deano478]

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], ",", ""))

[TheMattLeonard]

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.