View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
OriginalStealth OriginalStealth is offline
external usenet poster
 
Posts: 2
Default Formatting Zeros

I have a spreadsheet with currency values in cells D16-
H50. Column H is the last column in the spreadsheet. How
can I automatically have all the cells with a 0 in it
change to the dash(-) when it's is opened?

I Really need the code because I suck at excel.

Thanks in advance.
OS