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.