View Single Post
  #3   Report Post  
N Harkawat
 
Posts: n/a
Default

before entering data go to Format-Cells-Text
This will now allow you to enter the data with 0 prefixed to a number
OR
Enter ' before your number

"cajundoc" wrote in message
...
How do I start an Excel cell entry with the number 0? (i.e. a pin number
or
zip code). Every time I enter it, then move out of the cell, the computer
automatically removes the 0 in front of the remaining numbers.