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

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

"Janie" wrote:

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

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.

--
Rick (MVP - Excel)


"Janie" wrote in message
...
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