Pasting fractions from Word; changing into dates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ed - 19 Oct 2006 21:26 GMT

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

Reply to this Message

Andrea Jones - 19 Oct 2006 22:23 GMT

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

> 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

Reply to this Message

Ed - 19 Oct 2006 23:36 GMT

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,
[quoted text clipped - 15 lines]
>>
>> Ed

Reply to this Message