How can I keep zeros in the beginning of a number in excel
 

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?

How can I keep zeros in the beginning of a number in excel
 

To enter it as text, either precede the entry with an apostrophe or preformat
the col as Text. If you want it retained as numbers but to display the
leading zeros in the cells, preformat the col as custom, type: 0000 (for
example)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Starprincess" wrote:
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?

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?