Format numbers in a formula

[yme]

I'm trying to use a formula to concatenate number fields into a string field, but it always gives me numbers with two decimal places. I want it to look something simalar to "1000-3", where 1000 is the first number and 3 is the second, instead of "1,000.00-3.00". How would I do this. Thanks for your input.

 

[malk]

Try using the totext function.

ToText(123.45)
Returns "123.45".

 

[pamplemousse]

In File/Options/Fields/Number set your decimal place

 

[kenhamady]

Try:

Totext({field}, 0 , "" )

This eliminates the decimals and comma. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal