error while copying number from Notepad


V

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

Advertisements

M

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
 
Ad

Advertisements

A

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
 

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

Top