error while copying number from Notepad

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi,

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

Mike
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel And Notepad 3
How to stop Excel adding quotation marks when copying to notepad? 3
How can I copy plain text from Excel to Notepad? 5
Notepad Visual Basic and Excel 7
I open my nokia mobile contacts in notepad plus plus. cant view now.. help me!!! 4
how to convert a column into a row 3
Can I format a number display with a fixed exponent? 2
Converting list of numbers in Excel to a string of text in Word 2

Back
Top