how do i enter numbers starting with zero in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top