How to change comma format?

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
dbarbul
Posts: 12
Joined: Tue Oct 10, 2017 12:44 pm

How to change comma format?

Post by dbarbul » Tue Oct 28, 2008 9:49 am

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
Top
kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: How to change comma format?

Post by kfleming » Tue Oct 28, 2008 10:04 am

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
Top
Post Reply

Return to “R&R ReportWorks Users”