Report Number format displaying incorrectly

[mrhopko]

Hi All

I have created a report from a query. The report contains some numeric fields.
I have set the format of the numeric fields to #,###;#,###;0;0;
Despite this setting, my report is showing numbers as #.###
How can I solve this?

Much thanks for any help received

mrhopko

 

[mrhopko]

OK. Solved it.
My report also had some conditional formatting rules applied. It seemed that the conditional formatting rule had a strange format that was overriding the format of the field.

I removed the conditional formatting and the formatting displayed correctly.