I have a column of data in Word that contains info like, K-12, K-6, P, 9-12,
6-8. When I copy the data to Excel, the cells with the letters copy
correctly, but the cells with the numbers convert to dates. I've tried
pre-formatting the target cells in Excel, I've tried Data | Text to Columns,
I've tried preceding the data with a single apostrophe before copying the
data from Word. Incidently, this "works" but when I find and replace the
apostrophe, the text gets converted to a date! Can anyone help? Thanks in
advance.
--
Christine