Formatting cells

[**{Steven}**]

Is there a way to dual format a cell? I have a sheet that uses monetary
values, so it is formatted to show 2 decimal places. I also want to format
them, so that if the value is zero, nothing shows. Can I do that and if so,
how?

TIA

Steven Connor

 

[Frank Kabel]

Hi Steven
try the custom format
0.00;-0.00;

 

[**{Steven}**]

Thank you, that worked just great.

Steven

Hi Steven
try the custom format
0.00;-0.00;

 

[patti]

this is cool, I have all kinds of spreadsheets at work this would be great
for. Are there any limitations or problems I should watch out for?

 

[Frank Kabel]

Hi
no limitations but this can sometimes be confusing for a user.

 

[**{Steven}**]

The way I have mine set up is cells that you enter infomation into and that
places the info in the area that will actually be printed. The printed area
is a form. That way, they cannot mess with the form or change the formulae
and the entry cells show 0 when empty, while the form cells show nothing.

 

[patti]

I'm the main user so it should be ok. I'll be sure to warn the others I
work with tho.

 

[Dave Hawley]

Just for benefit of others. You can set this on a Worksheet level via
Tools>options-View "Zero Values".

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****