copy and paste problem

D

Derrick

I have a table that looks like this in Word:

header1 header2
row1 1-2 5-17
row2 1-1 9-20


When I try to paste the information into excel, excel converts the values to
dates. I tried to format them as text, but then it displays the serialized
value for that data.

Is there any way to stop that?

Derrick
 
D

Doug Kanter

Format the target cells as text BEFORE you paste, and use Paste, Special,
Text.
 
P

Peo Sjoblom

You have discovered one of MS less pleasant sides
One way would be to paste the values to let's say Notepad,
save it as a txt file. Then open the txt file in Excel and the text
import wizard will start, then you click next twice, then select
text under column data format and finally click finish
 
Top