SOLVED

Truncation of 'Tracking #' in cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2017285%22%20slang%3D%22en-US%22%3ETruncation%20of%20'Tracking%20%23'%20in%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2017285%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20sheet%20that%20I%20started%20to%20help%20me%20to%20keep%20track%20of%20my%20online%20orders.%20Everything%20is%20working%20according%20to%20my%20wants%2Fneeds%20except%20for%20the%20%E2%80%98Tracking%E2%80%99%20column.%20Whenever%20I%20enter%20a%20tracking%20number%20(such%20as%3A%26nbsp%3B%209361289675091102837463)%20it%20changes%20it%20to%20%E2%80%989.3612896750911E%2B21%E2%80%99.%20How%20do%20I%20get%20around%20this.%20Everything%20that%20I%E2%80%99ve%20tried%20so%20far%20hasn%E2%80%99t%20worked.%20Thank%20you%2C%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2017285%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2017326%22%20slang%3D%22en-US%22%3ERe%3A%20Truncation%20of%20'Tracking%20%23'%20in%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2017326%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F684000%22%20target%3D%22_blank%22%3E%40dlcartin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ENumber%20stored%20in%20cell%26nbsp%3B%20has%20limit%20and%20is%2C%2015%20digit%20floating-point%20numbers.%20If%20you%20want%20more%20than%2015%20digits%20you%20have%20to%20use%20Text%20rather%20than%20Numbers%2C%20but%20you%20may%20find%20some%20issue%20with%20further%20calculation%2C%20but%20if%20is%20only%20entering%20numbers%2C%20then%20format%20cells%20as%20TEXT.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2017327%22%20slang%3D%22en-US%22%3ERe%3A%20Truncation%20of%20'Tracking%20%23'%20in%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2017327%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F93699%22%20target%3D%22_blank%22%3E%40Rajesh-S%3C%2FA%3EWorks%20perfectly!!!!!%20Thank%20you!!!!!%20No%20calculations%20are%20necessary%20for%20this%20column%2C%20it's%20just%20a%20data%20keeper.%20Again%2C%20thank%20you%20for%20your%20valuable%20time%20%26amp%3B%20knowledge.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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 (such as:  9361289675091102837463) it changes it to ‘9.3612896750911E+21’. How do I get around this. Everything that I’ve tried so far hasn’t worked. Thank you, in advance.

3 Replies
Best Response confirmed by dlcartin (Occasional Contributor)
Solution

@dlcartin 

 

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-SWorks 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 ☺