View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Custom number format thousands and zeros as "-"

See your other post.

Regards,
Fred

"jchick0909" wrote in message
...
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!!!