In a separate cell enter:
=LEFT(A1,1)+MID(A1,2,1)/RIGHT(A1,1)

This works for very simple cases, but if you have something like:

111/25

we can't tell if its
11 & 1/25
or
1 & 11/25
--
Gary''s Student - gsnu200731


"Dig" wrote:

Is there anyway in Excel to format a cell so if the user types 61/4 it will
convert to 6.25? If not what is the best way to create a conversion so the
user can type in 51/2 and have 5.5 show up, either in another cell or in the
same cell?

Thanks for the help