Transfer Notepad to Excel problem ?

serge

Well-known Member
Joined
Oct 8, 2008
Messages
1,399
Office Version
  1. 2007
Platform
  1. Windows
When I copy and paste this number of 20 digits long into excel I only get the first 15 digits and the rest are 0 ?

44331332211232211133 when I paste to excel I get this below.
44331332211232200000

The last 5 digits are not transfer correctly.
What need to be done ?

thank you.
Serge.
 
Last edited:

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
Save the Notepad file as .txt or .csv and then open it the normal way in Excel - do you have the same problem?
 
Upvote 0
Thanks Ali, I tried every way I can, don't work :confused:
 
Last edited:
Upvote 0
I can confirm the issue. I can get the data in as text, but as soon as it is converted to a number, it gets changed.
 
Upvote 0
No. I've just been Googling it and the only solution offered is to store the numbers as text, which can be done when you open a .txt file in Excel, but that's it. 15 digits in a cell is Excel's limit.
 
Upvote 0
OK thanks again, so at the end I can not do it, I really needed those 20 digits.
Is there a way to select only half of the Notepad, like the first 10 digits on the vertical then I would do the other half, just an idea maybe not possible either.

Well, Thank you for your help, I appreciate it.
Serge.
 
Upvote 0
It won't help. If you import the data as text into one column you can then split it into two, however as soon as you try to combine the two columns again formatted as numbers, the problem will reoccur.
 
Upvote 0

Forum statistics

Threads
1,213,515
Messages
6,114,080
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top