# number forced to scientific notation [closed]

Version: 4.2.5.2

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

I have found a convoluted solution, I first paste the history data into writer, where it displays the number correctly, I then put a tic mark in front of the long number, and copy and paste that into the spreadsheet with paste special and choose HTML markup language and it now paste the long number correctly.

Wouldn't it be easier, to just have a check box on the Paste Special function that asked "treat long numbers as text" ?