View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Number Formating

Use custom format: 0000000000 (ten zeros, if my glasses are clean this
morning)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"JW" wrote in message
...
I want to use numbers begininng with a zero such as 0100100111 the lead
zero
keeps going away. I think that I overcame that at one time but I don't
remember how. Help
--
JW