View Full Version : Help with commas for report values...


scottmfitzge
08-05-2009, 03:08 AM
Hi - I have created a report, which shows some currency amounts - in the properties for this value, the format is "Currency" which means the value appears as £23,983,938.00 however, I don't want the £ sign to be shown. I want the value to appear as 23,983,938.00. If i have no format, it appears as 23983938.00 - any ideas how i include the commas?

Cheers, Scott

boblarson
08-05-2009, 06:34 AM
Don't format as Currency, but instead you can use a format of

#,##0.00

scottmfitzge
08-05-2009, 08:23 AM
Works perfectly - Thanks for your guidance.

Cheers, Scott