Page 1 of 1

How to change comma format?

Posted: Tue Oct 28, 2008 9:49 am
by dbarbul
How to change comma format form (999.999.999,99) to -999.999.999,99?____I am using R&R for Windows Version 10+____Dusan

=> RE: How to change comma format?

Posted: Tue Oct 28, 2008 10:04 am
by kfleming
Selecting comma format only allows for () negatives. If you want minus signs and commas you could create a calculated field using the TRANSFORM function.____TRANSFORM(-1234.56,"999,999.99) will return the character string__ -1,234.56____Kathleen__R&R Support