| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbering
I have a listing of 16 digit numbers in Microsoft Word. (################)
that i need to put into Excel. When i copy it and paste into Excel it converts the last number to a zero. Is there a way to make this not happen? I have probably 300 cards to copy and paste |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Numbering
XL has a limit of 15 digits of precision. If these "cards" are, say,
credit card numbers, format the cells as Text before pasting. In article , John wrote: I have a listing of 16 digit numbers in Microsoft Word. (################) that i need to put into Excel. When i copy it and paste into Excel it converts the last number to a zero. Is there a way to make this not happen? I have probably 300 cards to copy and paste |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Numbering
But it gives me that scientic notation. I copied it from word and pasted
"special" into Excel and it gave me that error. "JE McGimpsey" wrote: XL has a limit of 15 digits of precision. If these "cards" are, say, credit card numbers, format the cells as Text before pasting. In article , John wrote: I have a listing of 16 digit numbers in Microsoft Word. (################) that i need to put into Excel. When i copy it and paste into Excel it converts the last number to a zero. Is there a way to make this not happen? I have probably 300 cards to copy and paste |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Numbering
The scientific notation is just because the parser's interpreting it as
a number. It works for me when I paste special as Text. In article , John wrote: But it gives me that scientic notation. I copied it from word and pasted "special" into Excel and it gave me that error. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Numbering
Guaranteed that you *didn't* follow John's instructions to format the cells
as TEXT ... *BEFORE* pasting! -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "John" wrote in message ... But it gives me that scientic notation. I copied it from word and pasted "special" into Excel and it gave me that error. "JE McGimpsey" wrote: XL has a limit of 15 digits of precision. If these "cards" are, say, credit card numbers, format the cells as Text before pasting. In article , John wrote: I have a listing of 16 digit numbers in Microsoft Word. (################) that i need to put into Excel. When i copy it and paste into Excel it converts the last number to a zero. Is there a way to make this not happen? I have probably 300 cards to copy and paste |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I switch my numbering in Excel from Spanish to English? | Excel Discussion (Misc queries) | |||
| Format page numbering to be Page 1 of X | Excel Discussion (Misc queries) | |||
| start page numbering after table of contents | Excel Discussion (Misc queries) | |||
| Need help in numbering a column while skipping lines | Excel Worksheet Functions | |||
| numbering macro | New Users to Excel | |||
Linear Mode
