View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default error while copying number from Notepad

Hi,

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

Mike

"vipul" wrote:

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.