Inches to Millimeters function

Tami · Dec 6, 2004

Is there a function in excel that can convert inces to millimeters?

Thanks in advance for your help,
Tami

N Harkawat · Dec 6, 2004

=A1*25.4

Dave R. · Dec 6, 2004

Here you go

=CONVERT(A1,"in","m")*1000

Dave R. · Dec 6, 2004

oops, just noticed that you can use "mm" instead of "m" and can drop the
*1000 part.

Harald Staff · Dec 6, 2004

Multiply by 25.4, there are 25.4 millimetres in each inch.

HTH. Best wishes Harald