View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Atul Jadhav Atul Jadhav is offline
external usenet poster
 
Posts: 1
Default error while copying number from Notepad

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



"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.