Forum Discussion
Solved
Truncation of 'Tracking #' in cell
I have a sheet that I started to help me to keep track of my online orders. Everything is working according to my wants/needs except for the ‘Tracking’ column. Whenever I enter a tracking number (suc...
Number stored in cell has limit and is, 15 digit floating-point numbers. If you want more than 15 digits you have to use Text rather than Numbers, but you may find some issue with further calculation, but if is only entering numbers, then format cells as TEXT.
Number stored in cell has limit and is, 15 digit floating-point numbers. If you want more than 15 digits you have to use Text rather than Numbers, but you may find some issue with further calculation, but if is only entering numbers, then format cells as TEXT.
Rajesh_SinhaWorks perfectly!!!!! Thank you!!!!! No calculations are necessary for this column, it's just a data keeper. Again, thank you for your valuable time & knowledge.
- Glad to help you,, please keep asking ☺