View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jchick0909 jchick0909 is offline
external usenet poster
 
Posts: 11
Default Custom number format thousands and zeros as "-"

I am currently using

#,###, to format my numbers in thousands, but I also need zeros to show
as a dash "-"

Thanks in advance for your help!!!