error while copying number from Notepad

[vipul]

I have received error while i copy and paste number (more than fourteen)from
Notepad to Excel for Example if i type 123456789123456 in Notepad and copy to
paste in Excel i get the out put like that 1.2345E+15. so please let me know
what should i do in this error.

I have tried to solve that error like (Format/cell/number-0) i get the out
put 123456789123450 when i want to 123456789123456.

so pls. guide me.

 

[Mike H]

Hi,

Excell simply can't handle numbers that large. If you want to see the number
as input then format it as text.

Mike

 

[Atul Jadhav]

pl as follow

past in exl cell, change cell size with 15.43, change format of cell by
formating cell, select number than 0 digit