Thread: leading zeros
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Dave[_11_] Dave[_11_] is offline
external usenet poster
 
Posts: 41
Default leading zeros

Hi All,

I have an issue with formating cells. I have a permit number that has
leading zeros sometimes, so I must display them when entered. I have
tried 0?-??????? and 0#-####### but no luck. Heres is what my permit
number look
01-2345678 & 02-8765432.


thanks,

Dave