View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dewayne Dewayne is offline
external usenet poster
 
Posts: 49
Default Number format in a Macro

I have the following number format code in a macro which gives me what I need
except then the cell value is 0, I need it to indicate a "-" (hyphen) or just
remain blank.

Selection.NumberFormat = "#,##0.0_);(#,##0.0)"

Any help would be appreciated.
Thank you,
--
Dewayne