conditional formatting

**rwl518p** · 04-27-2011, 06:40 AM

Is there a way to apply a condititional format to a column to make a minus figure display as a zero?

macke

**contaminated** · 04-27-2011, 06:49 AM

Try custom cell formatting

##;"0";0

**rwl518p** · 04-27-2011, 07:05 AM

Hi that works brilliant thanks.

What if the figure was 0.23 and I wanted this as a 0, but retaining the format of 2 decimal places.

macke

**daddylonglegs** · 04-27-2011, 07:30 AM

Originally Posted by rwl518p

Hi that works brilliant thanks.

What if the figure was 0.23 and I wanted this as a 0, but retaining the format of 2 decimal places.

macke

Can you give some examples? 0.23 should display as what - 0 or 0.00?

What about 1.23 or 123.74?

**martindwilson** · 04-27-2011, 07:19 AM

try just format as
General;"0"

Re: conditional formatting