View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
khennet khennet is offline
external usenet poster
 
Posts: 5
Default personal numberformat

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 thank