Hi, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.
I am very sorry about your issues. Can you please give me a sample tracking number that you are entering to a cell and tell me also the "equation" that this tracking number has become?
Also, if you can send me a copy of the Excel file, it will be very helpful so that I can work on the file directly and it back to you when done. You can use the paper clip icon in the reply box to attach the sample Excel file.
Please let me know by replying to me here so that I can help you further.
Hi, thank you for writing back. Please give me a moment to check the attached file
In the sample file you gave me, what exactly is the tracking number that you entered before it was transformed?
Just give me few tracking numbers as a sample so that I can check the pattern
I am referring to the tracking numbers in R. For instance, it is now showing 9.40011E+21 in cell R2. But what exactly is the tracking number that you entered there that automatically changed to 9.40011E+21?
Hi, thank you for writing back with the samples of your tracking numbers. Please give me a moment to set your excel file correctly.