How do I change a text fraction. eg 1 1/2 into a decimal number, .

How do I change a text fraction. eg 1 1/2 into a decimal number, 1.5, using
excel 2000

Copy an empty cell, select the fraction and do edit>paste special and select
add
If it is a number fraction like # ?/? just change the format ot a number or
general

--

Regards,

Peo Sjoblom


"antac" <[email protected]> wrote in message
news:[email protected]...
> How do I change a text fraction. eg 1 1/2 into a decimal number, 1.5,
using
> excel 2000