I'm having a problem with imported data automatically converting to dates. I
paste in some data from word which is automatically converted into columns.
One of the columns contains chapter-page number data such as 1-2, or 5-4,
etc. Excel automatically converts that to a date format, which then can't be
converted back to text except as the number corresponding to that date- such
as 38694, etc. The paste of the data overrides any preset "text" format for
those cells. How can I import the data without having it convert to a date?

Thanks.