G
Guest
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?
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?