Pasting fractions from Word; changing into dates

[Ed]

I am trying to paste a row of fractions in a Word table into an Excel
worksheet. The column is formatted as Fraction. But every Paste and Paste
Special I try puts these in and converts them to dates! Is there any way
around having to type these in by hand?

Ed

 

[Andrea Jones]

You can make it work if you put a 0 in front of each fraction in your Word
document and then copy and paste that into your fraction formatted cells,
e.g. to copy and paste

1/2 3/4

you would enter them in Word as

0 1/2 0 3/4

A Jones

 

[Ed]

Very nice, Andrea! Thank you!
Ed

You can make it work if you put a 0 in front of each fraction in your Word
document and then copy and paste that into your fraction formatted cells,
e.g. to copy and paste

1/2 3/4

you would enter them in Word as

0 1/2 0 3/4

A Jones