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" <antac@discussions.microsoft.com> wrote in message
news:94D66753-148C-408F-AAE1-025411489C13@microsoft.com...
> How do I change a text fraction. eg 1 1/2 into a decimal number, 1.5,
using
> excel 2000