It works for me in MacXLv.X, and it should work in XL00. Do you have the
Tools/Options/View/zero values checkbox checked?

In article ,
"khennet" wrote:

hi,
i have some problem, wheni use a code from excel 97 to excel 2000.

what i want is when a cells contains "0,00" i want it shows " - "
i have a personal format like == Selection.NumberFormat = "#.00##;-#.00##;-
;"
this format work well in excel97 but not in excel 2000.
it doesn't display data!! (excel 2000), it hides all data.

it works in this = Selection.NumberFormat = "#.00##;-#.00##;"

can u give my a hand, please thanks