View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Doctorjones_md Doctorjones_md is offline
external usenet poster
 
Posts: 64
Default How can I keep zeros in the beginning of a number in excel

On the Menu Bar, click Format, Cells, Number, and choose Custom -- enter
0000 in the field titled "Type"

HTH

"Starprincess" wrote in message
...
Everytime I type in a number that starts with zeros in an excel cell -
excel
automatically drops the zeros from the number how can I format the cell to
keep the zero?