formatting numbers

  • Thread starter Thread starter Derrick
  • Start date Start date
D

Derrick

Hi again!
i want to format my cells so that if i have a '0' value, the cell is blank.
if it's non-0, i would like it to show up. sounds simple i hope
Thanks
 
Right click>Format Cells>Custom format CElls to

0;-0;""

with decimals
0.00;-0.00;""

If this post helps click Yes
 
Jacob,
This is just what I was looking for as well.

It sure did help me out.

I've clicked on the YES to show it was helpful.

John
 
Back
Top