Showing 0.00 in a single cell

[RobbieC]

Hi there, I have a sheet where I have disabled 'show zero in cell where cell value is zero' in advanced options...

However I have one cell where I would like 0.00 to appear. The cell is formatted as a number to 2dp

If I re-enable the advanced setting to show zeros, the entire sheet fills with zeros... Is there a way to come up with a compromise?

If you can point me in the right direction, I'd be very grateful

Many thanks

Rob

 

[jmacleary]

Hi there.

If your cell actually has to have a value of 0 I don't think you can do much about that (I stand to be corrected). If however, you can put a small value in, like 0.001, then your formatting rule will show it as 0.00.

Hope this helps.

 

[shg]

Hi there, I have a sheet where I have disabled 'show zero in cell where cell value is zero' in advanced options...

Undo that, and format the cells individually where you don't want zeros to appear. E.g., for two decimals but not zero, format as
0.00;-0.00;

 

[RobbieC]

Thanks guys, I will have a go and see what suits best for the sheet