Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
error while copying number from Notepad
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro error - copying data twice | Excel Discussion (Misc queries) | |||
macro error - copying data twice | Excel Discussion (Misc queries) | |||
Copying the number of a custom formatted number cell | Excel Discussion (Misc queries) | |||
Copy and Paste Number from Notepad | Excel Discussion (Misc queries) | |||
Error Copying Worksheet | Excel Worksheet Functions |