Have you tried paste special - value and formats?
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"lcshrm" wrote:

I'm trying to paste a series numeric data entered in the format ##-## into
another spreadsheet as text and not convert any to dates. No matter what I've
done so far, Excel converts any entry it can interpret as a date into a date.


For example:
2-18 0-18 12-33 3-36 7-32 0-60
pastes as
38766 0-18 12389 13210 11871 0-60

I need it to paste in its original state as text so that I can extract the
numbers before the - into a different row and then the numbers after the -
into another row.

Any ideas?
--
lcshrm