Forum Discussion
Solved
When I paste a long number, Excel turns it into scientific notation and changes numbers.
Here's an example. I have a long number (it's from a license plate/bar code): 00100018320523710862 Whether I use my bar code software's export-excel function, or PASTE the number directly, here is...
after pasting, click on the column, format cells, fraction and ok. That works for me. Keith Kargl
On Mac - You can simply select a "special paste" by holding CTRL + CMD + V and choose "Text". This retains the long number form of the number.
I'm not sure what the hotkeys are for Windows, but essentially select the option for special paste (sometimes found in the top Edit menu next to File).
I'm not sure what the hotkeys are for Windows, but essentially select the option for special paste (sometimes found in the top Edit menu next to File).
Excel Windows; Paste Special = Ctrl+alt+V