Hi guys,
Basically been trying to copy and paste a number from gmail to excel.
The number is: 10150209503312053
Excel changes the last 3 digits to 000. Example:
4c2aae21dcfdd0feec69588be2d532975b8e42ecd3.png
I need the exact number pasted.
I have tried pasting it as text, and played around with the decimals with no luck.
Any recommendations?
Cheers,
Chris
This is because Excel supports maximum of 15 digit number. Format cell as Text before you paste it. This should take care of the problem.
Last edited by AlKey; 10-15-2015 at 09:00 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks