| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste from Word table into Excel
I have a very simple table in Word that I need to get into Excel. It seemed
very easy to just cut and paste. Here's the problem, one column of information is an identification number fomratted like 1-00 4-03 5-01 Excel is interpreting this as a date. I thought I could choose paste values to avoid the conversion but it is grayed out. If I choose paste special, Excel recognizes the source (I guess) and I get to choose from a short list of things rather than what I am accustom to seeing when I choose paste special. Can anyone help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste from Word table into Excel
After you paste them into Excel try formatting them under text.
-- -SA "leezard" wrote: I have a very simple table in Word that I need to get into Excel. It seemed very easy to just cut and paste. Here's the problem, one column of information is an identification number fomratted like 1-00 4-03 5-01 Excel is interpreting this as a date. I thought I could choose paste values to avoid the conversion but it is grayed out. If I choose paste special, Excel recognizes the source (I guess) and I get to choose from a short list of things rather than what I am accustom to seeing when I choose paste special. Can anyone help? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste from Word table into Excel
Did that.
I get 36526 39541 39569 Thanks! "StumpedAgain" wrote: After you paste them into Excel try formatting them under text. -- -SA "leezard" wrote: I have a very simple table in Word that I need to get into Excel. It seemed very easy to just cut and paste. Here's the problem, one column of information is an identification number fomratted like 1-00 4-03 5-01 Excel is interpreting this as a date. I thought I could choose paste values to avoid the conversion but it is grayed out. If I choose paste special, Excel recognizes the source (I guess) and I get to choose from a short list of things rather than what I am accustom to seeing when I choose paste special. Can anyone help? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste from Word table into Excel
OK, this is what I did to get it to work:
Copy your Word table Right click at Excel destination and choose paste special Choose "Text" With the Paste Options thing click "Use Text Import Wizard" Click Next Check "Tab" Click Next Under Column data format click "Text" Click Finish. Should work! -- -SA "leezard" wrote: Did that. I get 36526 39541 39569 Thanks! "StumpedAgain" wrote: After you paste them into Excel try formatting them under text. -- -SA "leezard" wrote: I have a very simple table in Word that I need to get into Excel. It seemed very easy to just cut and paste. Here's the problem, one column of information is an identification number fomratted like 1-00 4-03 5-01 Excel is interpreting this as a date. I thought I could choose paste values to avoid the conversion but it is grayed out. If I choose paste special, Excel recognizes the source (I guess) and I get to choose from a short list of things rather than what I am accustom to seeing when I choose paste special. Can anyone help? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste from Word table into Excel
Using the steps you listed. When I choose "Text", the data pastes into
Excel. I can not find anything that resembles "With the Paste Options thing click "Use Text Import Wizard"". Thanks for your help. "StumpedAgain" wrote: OK, this is what I did to get it to work: Copy your Word table Right click at Excel destination and choose paste special Choose "Text" With the Paste Options thing click "Use Text Import Wizard" Click Next Check "Tab" Click Next Under Column data format click "Text" Click Finish. Should work! -- -SA "leezard" wrote: Did that. I get 36526 39541 39569 Thanks! "StumpedAgain" wrote: After you paste them into Excel try formatting them under text. -- -SA "leezard" wrote: I have a very simple table in Word that I need to get into Excel. It seemed very easy to just cut and paste. Here's the problem, one column of information is an identification number fomratted like 1-00 4-03 5-01 Excel is interpreting this as a date. I thought I could choose paste values to avoid the conversion but it is grayed out. If I choose paste special, Excel recognizes the source (I guess) and I get to choose from a short list of things rather than what I am accustom to seeing when I choose paste special. Can anyone help? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste from Word table into Excel
I'm using Excell 2003 so it may be slightly different if you're using a
different version. The "Paste Options thing" I was refering to is the past options that shows up after pasting in teh bottom right of the paste area. If you paste, a little tab shows up and gives you a number of options to choose from (formatting options, etc.). This is where you choose "Text Import Wizard" -- -SA "leezard" wrote: Using the steps you listed. When I choose "Text", the data pastes into Excel. I can not find anything that resembles "With the Paste Options thing click "Use Text Import Wizard"". Thanks for your help. "StumpedAgain" wrote: OK, this is what I did to get it to work: Copy your Word table Right click at Excel destination and choose paste special Choose "Text" With the Paste Options thing click "Use Text Import Wizard" Click Next Check "Tab" Click Next Under Column data format click "Text" Click Finish. Should work! -- -SA "leezard" wrote: Did that. I get 36526 39541 39569 Thanks! "StumpedAgain" wrote: After you paste them into Excel try formatting them under text. -- -SA "leezard" wrote: I have a very simple table in Word that I need to get into Excel. It seemed very easy to just cut and paste. Here's the problem, one column of information is an identification number fomratted like 1-00 4-03 5-01 Excel is interpreting this as a date. I thought I could choose paste values to avoid the conversion but it is grayed out. If I choose paste special, Excel recognizes the source (I guess) and I get to choose from a short list of things rather than what I am accustom to seeing when I choose paste special. Can anyone help? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste from Word table into Excel
Thank You...that worked great! I did not notice the paste options that show
up after the paste. "StumpedAgain" wrote: I'm using Excell 2003 so it may be slightly different if you're using a different version. The "Paste Options thing" I was refering to is the past options that shows up after pasting in teh bottom right of the paste area. If you paste, a little tab shows up and gives you a number of options to choose from (formatting options, etc.). This is where you choose "Text Import Wizard" -- -SA "leezard" wrote: Using the steps you listed. When I choose "Text", the data pastes into Excel. I can not find anything that resembles "With the Paste Options thing click "Use Text Import Wizard"". Thanks for your help. "StumpedAgain" wrote: OK, this is what I did to get it to work: Copy your Word table Right click at Excel destination and choose paste special Choose "Text" With the Paste Options thing click "Use Text Import Wizard" Click Next Check "Tab" Click Next Under Column data format click "Text" Click Finish. Should work! -- -SA "leezard" wrote: Did that. I get 36526 39541 39569 Thanks! "StumpedAgain" wrote: After you paste them into Excel try formatting them under text. -- -SA "leezard" wrote: I have a very simple table in Word that I need to get into Excel. It seemed very easy to just cut and paste. Here's the problem, one column of information is an identification number fomratted like 1-00 4-03 5-01 Excel is interpreting this as a date. I thought I could choose paste values to avoid the conversion but it is grayed out. If I choose paste special, Excel recognizes the source (I guess) and I get to choose from a short list of things rather than what I am accustom to seeing when I choose paste special. Can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to paste Word table into Excel 2003 intact? | Excel Discussion (Misc queries) | |||
| Paste Table from Word in Excel - 2000 -vs- 2002 | Excel Discussion (Misc queries) | |||
| Copy & Paste table from Excel to Word | New Users to Excel | |||
| paste excel table to word | Excel Worksheet Functions | |||
| Paste table from excel to word | Excel Worksheet Functions | |||
Linear Mode
