Tried that, pasting only the values, but still get the same results.
Anyone else have an idea?

--
lcshrm


"Farhad" wrote:

Hi,

First change the cells format to text and then enter the data.

Thanks,
--
Farhad Hodjat


"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