"compu_trainer" wrote:
.....
But when I use numbers like 3 7/16,
the conversion is not accurate unless I
place the whole number in one cell,
and the fraction in a separate cell,
then * each cell by 25.4 and then add them together...

FWIW ...
if you input in A1: 3, in B1: 7/16
with B1 formatted as Fraction (As sixteenths)
you could put in C1: =CONVERT(SUM(A1:B1),"in","m")*100
which yields: 8.73125
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----