Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Inches to Millimeters function
Is there a function in excel that can convert inces to millimeters?
Thanks in advance for your help, Tami |
#2
|
|||
|
|||
=A1*25.4
"Tami" wrote in message ... Is there a function in excel that can convert inces to millimeters? Thanks in advance for your help, Tami |
#3
|
|||
|
|||
Here you go
=CONVERT(A1,"in","m")*1000 "Tami" wrote in message ... Is there a function in excel that can convert inces to millimeters? Thanks in advance for your help, Tami |
#4
|
|||
|
|||
oops, just noticed that you can use "mm" instead of "m" and can drop the
*1000 part. "Tami" wrote in message ... Is there a function in excel that can convert inces to millimeters? Thanks in advance for your help, Tami |
#5
|
|||
|
|||
Multiply by 25.4, there are 25.4 millimetres in each inch.
HTH. Best wishes Harald "Tami" skrev i melding ... Is there a function in excel that can convert inces to millimeters? Thanks in advance for your help, Tami |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Averaging function | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
change function variable prompts?? | Excel Worksheet Functions | |||
Counting Function Dilemma | Excel Worksheet Functions |