Remove the comma from a number field in formula 2

[leightur]

How do you remove a comma when a formula contains text / number field?

For example:

"CARTON CONTAINS " & ToText ({CODEDEL.QTY_PER_BOX},0)

The QTY_PER_BOX = 1,280 and I would like the comma removing so it says 1280.

 

[Madawc]

Try ToText ({CODEDEL.QTY_PER_BOX},0, ""). This should tell it not to use the separator.

File > Options > Field should let you set defaults for all numerics, if you want to get rid of commas.

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.


Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[leightur]

Brilliant, that formula worked!

Thanks