Conditional Formatting

wem3rd

Registered User.
Local time
Yesterday, 16:41
Joined
May 4, 2014
Messages
13
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
 
Last edited:
Simplest is a format in the textbox like:

#.##
 

Users who are viewing this thread

Back
Top Bottom