I am copying the shipping history from my USPS account every day and pasting it into my libre office spreadsheet. This has always worked fine until recently. One of the fields is the confirmation number or label which displays on the USPS wesbite as a long integer such as 9405503699300349187201 and in the past when I pasted the table into the spreadsheet, that field would display as 9405503699300349187201. However, recently this behavior has changed and it now displays as 9405503699300350000000.
If I click on the cell and view the data in the input line, it appears as 9.40550369930035E+021 and at this point no matter what I do, I cannot convert the number back to the long number format of 9405503699300349187201 as the last eight digits have been lost.
How do I force the spreadsheet to not display the data in scientific notation 9.40550369930035E+021
Obviously, I cannot do anything to recover the original number after it is pasted into the spreadsheet. Is there some way to forbid the spreadsheet from defaulting to scientific notation. I never had this problem before the last couple of upgrades.
So, the number 9405503699300349187201 is pasting into a new spreadsheet (with no pre-formatting being done by me) as 9.40550369930035E+021 which displays in the cell as 940550369930035000000 and there is nothing I can do to convert it back as it has lost the last eight significant digits during the paste process.
Here is a link to a pdf file that shows how the spreadsheet (top) and USPS table (bottom) data appear