Fred wrote on Wed, 5 Sep 2007 20:46:12 -0600:

FS One way: Just enter into Excel the same formula you enter
in
FS the calculator.

FS --
FS Regards,
FS Fred

FS "Paula ;)" wrote in message
FS
oups.com...
?? Hi all,
??
?? I'm modifying a worksheet for our Quality Control dept.
?? where I have to take metric dimensions (millimeters) off a
?? print and convert them into English / Imperial (inches)
?? for the guys to check parts from.
??
?? Anybody know if there is a way to enter a metric dimension
?? and have it automatically convert to English / Imperial
?? rather than doing the conversion on a calculator and
?? entering the converted number in manually?

Not automatically replace with a function but you could have a
new column with the results...mm in A1, inches in B1
=CONVERT(A1,"mm","in")

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not