Formatting Worksheets

J

Janie

Is there anyway I can set up an entire worksheet that would display all zero
cells as dashes without writing a formula for each cell?
Thanks
 
E

Eduardo

Hi,
go to excel general options, advance , display options for this worksheet,
uncheck the one that says show a zero in cell that have zero value

if this helps please click yes, thanks
 
R

Rick Rothstein

Writing a formula in each cell wouldn't work because you would never be able
to enter your data without overwriting the formula. If you are not using any
Cell Formats on your worksheet, then you can try this Custom Cell Format...

0;-0;"-"

which, as written, assumes integer numbers in your cells. If you could have
floating point numbers, then you would need to change the zeroes to
something like this...

0.###;-0.###;"-"

where the number of # signs would equal the number of places to round your
values to (but note that whole numbers would display a trailing decimal
point). There is also a VB solution if you would like to consider that.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top