Formatting of a number field

[diannelight]

Hi! There is probably a very easy explanation for this but I've tried everything I know.
I have a number field in the database that shows up on my report as '9,001' - I want it to read '9001'. Any tips?
Thank you.

 

[Naith]

Hi Dianne,

Right click the field, Format, Number, Customise, Uncheck Thousands Separator.

Naith

 

[diannelight]

Hi Naith, thanks again for helping.
I've already tried this - any other suggestions?

 

[Naith]

If this is a genuine number field, that should be all you need to do.

You could also try converting with ToText({YourField},'#'), Give that a shot.

Naith

 

[diannelight]

ToText works - thank you!