View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Keep Leading Zero

To display 123 as 0123 use the custom format "0000" (no quotes, of course)
happy new year
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Sean Timmons" wrote in message
...
This has to be an easy one, but I can't find it. How do I retain the
leading
zero in a number and retain number formatting?