number format

[Viking88]

I have a large number I am hardcoding into a cell, but when I hit enter the last number turns to a zero. I originally thought it may have been the way the cell was formatted, but I went through them all and none of them seem to correct the problem.

Has anyone else had this happen to them?

 

[pgc01]

Hi Viking88

Numbers in xl have a maximum of 15 significant digits. If you need to enter a name with more digits, enter it as text (for ex. format the cell as text before entering the number).