Conditional Formatting (1 Viewer)

[wem3rd]

I would like to have a listing in a report show two decimals only when that value has decimals to show (eg >.00), All other values would display with no zeros at all.

For example, record #1 = 23.05, #2 = 22.11, #3 = 24, #5 = 23.58, #6 = 22

etc.

Any help on how to write a rule for conditional formatting for this?

Thank you.

wem3rd

 

[pbaldy]

Simplest is a format in the textbox like:

#.##