entering numbers that begin with zero

[Shannon]

I often enter manufacturer model#'s into my spreadsheet. If they begin with
zero Excel automatically the zero. What can I do to change this?

 

[Imonit]

I often enter manufacturer model#'s into my spreadsheet.  If they beginwith
zero Excel automatically the zero.  What can I do to change this?

You can format the cells to accept leading zero's. From the format
cells window, look for custom number formats, then in the Type field
type

0000 , with each zero representing the number of digits you want to
have displayed.

HTH!

-Imonit

 

[gls858]

You can format the cells to accept leading zero's. From the format
cells window, look for custom number formats, then in the Type field
type

0000 , with each zero representing the number of digits you want to
have displayed.

HTH!

-Imonit

Or you could simply format that column as text instead of number.

gls858

 

[pamelia123]

Hi Shannon

Change the cell address to a text field - format-cell-select text from the
category list.

 

[Convert94]

I learned from the answers myself because I used to just type an apostrophe
before entering the number then the zero would appear.