Browse » Home
Sunday, May 22, 2011
How to Convert Inches to Millimeters in Excel 2003
1. Enter your measurement data (in inches) into Excel, and label the column so that you know what units the data are in (for example, 'Length (inches)'). Here you can assume that the first data point is in A2, and the rest follow in the same column (A3, A4, A5).
2. Label the next column so that you know that the data is expressed in millimeters (for example 'Length (mm)').
3. Enter the following formula in cell B2:=CONVERT(A2,'in','mm')This tells Excel to look up the value in cell A2, and convert it from inches to millimeters.
4. Copy and paste this formula down so that all your data are converted. Excel will automatically look up the correct cell, so the formula in B3 will be converting the value in A3, the formula in B4 will be converting the value in A4, and so on.