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.