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

You can also enter the 'number' as 'o123 (leading quote, and then right
justify it
This will still 'function' as a numeric value
--
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?