entering numbers that begin with zero
 

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?

entering numbers that begin with zero
 

On Sep 10, 1:15*pm, Shannon wrote:
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?

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

entering numbers that begin with zero
 

Imonit wrote:
On Sep 10, 1:15 pm, Shannon wrote:
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?

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

entering numbers that begin with zero
 

Hi Shannon

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

"Shannon" wrote:

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?

entering numbers that begin with zero
 

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

"Shannon" wrote:

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?