Help with commas for report values...

[scottmfitzge]

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]

Don't format as Currency, but instead you can use a format of

#,##0.00

 

[scottmfitzge]

Works perfectly - Thanks for your guidance.

Cheers, Scott