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 How do I get excel to leave a zero in front of a number?

Custom format 0000
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"elmo" wrote in message
...
I am trying to list bus numbers for my students and excel won't let me type
0176. It keeps taking away the zero and leaving 176. I even tried
putting a
decimal point in front and then it added a zero 0.0176.