how do i enter numbers starting with zero in excel
 

i am trying to enter account numbers into my worksheet but when i hit return
it removes the leading zeroes, how do i keep them.

FORMAT / CELLS / NUMBER / TEXT
ok
HTH,
--
Gary Brown



"achitsyerself" wrote:

i am trying to enter account numbers into my worksheet but when i hit return
it removes the leading zeroes, how do i keep them.

Type a leading apostrophe - makes it text, which is fine for numbers you're
not going to use in arithmetic calcs.
Bob Umlas
Excel MVP

"achitsyerself" wrote in message
...
i am trying to enter account numbers into my worksheet but when i hit
return
it removes the leading zeroes, how do i keep them.

If all account numbers fall under a certain column and are a certain length,
click on the column header to select the whole column, choose format cells
and under "number" tab select "custom". In the space available under this
selection input zeroes to the digit length that the account numbers are.

This will add zeroes to the beginning of all numbers input into cell until
the total length meets the digit lenth of the zeroes input into the customer
section. It also keeps the value as a number.

"achitsyerself" wrote:

i am trying to enter account numbers into my worksheet but when i hit return
it removes the leading zeroes, how do i keep them.