Format the cell as text and then enter the nuimber
or
Prefix ' and then your number on each cell

"rydog" wrote in message
...
I am trying to type in a 20-digit number and when I press enter, the last 5
digits turn into zeros. How can I keep all the numbers that I entered
without
them automatically turning to zeros?