View Single Post
  #2   Report Post  
Andy Brown
 
Posts: n/a
Default

"Christine" wrote in message
...
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 ...


Pre-format the target cells ; then use Paste Special -- Text.

Rgds,
Andy