Of course will not work if you really want to view "real" zeros since they
will not be visible

General,-General;;

whatever number format you use end with 2 semi colons

0.00;-0.00;;

you can also turn them off via toolsoptionsview but that will affect the
lot, this will only affect those that you format and you can use the format
painter

--
Regards,

Peo Sjoblom

(No private emails please)


"statusquo" wrote
in message ...

That will work, but it's a real pain to write that every time,
especially when I'm using an indirect to a different sheet, so the
formula gets extremely long. Is there some sort of formatting option
that can help fix this for me?


--
statusquo
------------------------------------------------------------------------
statusquo's Profile:
http://www.excelforum.com/member.php...o&userid=29501
View this thread: http://www.excelforum.com/showthread...hreadid=492931