Transfer Notepad to Excel problem ?

[serge]

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.

 

[serge]

No it wont because I'm separating each digits into a single cell, I just needed the transfer those numbers from Notepad to excel.

 

[AliGW]

I'm confused. Do you want the number in one cell or each digit in a separate cell? If the latter, then that is easy.

 

[serge]

I need each digit in a separate cell.

 

[AliGW]

OK - that's easy. So, when you open the .txt file in Excel by going to File | Open ... , you will get the text to columns dialog. Choose fixed width, then click next. In the data preview at the bottom click after each number to add a break. The rest is straightforward, I think.

 

[serge]

It works, Thank you Ali, I really appreciate the help, very nice job.
Regards, Serge.

 

[AliGW]

You're welcome!