Number format in Crystal

[dannyb29]

Hi All,
Is there a formula i can use to change the format of a product code (number) Example

From: 2,100.00
To: 2100

For some reason who ever created the database did not do this from the out set.

Many Thanks

 

[lbass]

Right click on the field->format field->number and select the desired format.

Or, if you are using the field in a formula, you can convert it to a string and change the format like this:

totext({table.productcode},0,"")

-LB

 

[dannyb29]

Thank you, LB. The formula works fantastically!