This worked in xl2002:

#.00##;-#.00##;- ;@

When I did it manually.

So ....

Selection.NumberFormat = "#.00##;-#.00##;- ;@"

Should work ok in code?????



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

--

Dave Peterson