Forum Discussion
Stop Excel from Rounding Long Numbers on Paste
This has been asked many times, in many places, and I still don't have a functional solution. I'm looking for some sort of permanent setting that will prevent Excel from rounding pasted long numbers....
The limitation of 15 digits is defined in the Excel specification, unfortunately you cannot change it.
This limitation has applied to all versions of Excel for years.
You probably know this, judging from your text :).
The only thing that comes to mind is to format the cells/ranges/worksheet as text in advance.
Then paste the copied numbers in the paste options with "Match line formatting (M)".
So you get all the numbers exactly as you had them before.
You can then reformat the cells as numbers using "Format Cells...".
I very much doubt whether you can also carry out calculations with it, because the +15 would appear again.
I hope that this information could help you a little.
I know I don't know anything (Socrates)