| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy and Paste Number from Notepad
I have a list of numbers that we are trying to copy and paste from Note Pad
to Excel. When we change the format in Excel from text to a number, it changes the last digit to "0". Please help! Notepad: 4233750100024844 4233750100046276 Excel: 4233750100024840 4233750100046270 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy and Paste Number from Notepad
all is revealed here
http://support.microsoft.com/default.aspx/kb/269370 "Carter68" wrote: I have a list of numbers that we are trying to copy and paste from Note Pad to Excel. When we change the format in Excel from text to a number, it changes the last digit to "0". Please help! Notepad: 4233750100024844 4233750100046276 Excel: 4233750100024840 4233750100046270 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy and Paste Number from Notepad
Mike, you are a lifesaver!!
Thanks a bunch! "Carter68" wrote: I have a list of numbers that we are trying to copy and paste from Note Pad to Excel. When we change the format in Excel from text to a number, it changes the last digit to "0". Please help! Notepad: 4233750100024844 4233750100046276 Excel: 4233750100024840 4233750100046270 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| Copy / Paste Warning | Excel Discussion (Misc queries) | |||
| Copy and paste | Excel Discussion (Misc queries) | |||
| Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
| Can't Copy and Paste between Excel 2003 Workbooks | Excel Discussion (Misc queries) | |||
Hybrid Mode
