Forum Discussion
Length of a number in an excel cell
I can't seem to type in some tracking numbers correctly. The number is correct for only so many characters and then it all changes to 0's so the number is never correct. It seems to be cutting off ...
When the cell is changed to "text" I get a weird number. I get 9.40011E+21
Here is the number I typed to text field... 9400111298370453148099. When the field is a number I get 9400111298370450000000.
Here is the number I typed to text field... 9400111298370453148099. When the field is a number I get 9400111298370450000000.
- Your attachment was helpful. Thank you. It looks like the cell needs to be a text field BEFORE I put any data in it. Don't understand this because I have always been able to change a cell once I have put data in it with no issues. Also, if I try to copy a track number (no link) when I paste it I have to do a special paste and check the text box. Seems like a lot a work and should be easier but I did get that to work.