entering numbers that begin with zero

  • Thread starter Thread starter Shannon
  • Start date Start date
S

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?
 
I often enter manufacturer model#'s into my spreadsheet.  If they beginwith
zero Excel automatically the zero.  What can I do to change this?
Click to expand...

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
 
Imonit said:
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
Click to expand...

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

gls858
 
Hi Shannon

Change the cell address to a text field - format-cell-select text from the
category list.
 
I learned from the answers myself because I used to just type an apostrophe
before entering the number then the zero would appear.
 
Back
Top