Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Office 97 to 2003: Excel: enter data w/fixed 2 decimal. 2000. be. | New Users to Excel | |||
Office 97 to 2003: Excel: enter data w/fixed 2 decimal. 2000. be. | New Users to Excel | |||
In Excel, how to sum top 10 greatest values in a row of numbers? | Excel Worksheet Functions | |||
how do i set up to auto detect duplicated numbers in an excel fiel | Excel Discussion (Misc queries) | |||
How do I stop Excel from changing simple numbers to their 1/100th. | Excel Discussion (Misc queries) |