Change Unit Of Measurement For Cells. Go to the Advanced section of your Excel Options from the tabs on the left Scroll to the Display section. Click OK when done.
For example you want to change the unit of measurement for cell C1 from inch to meter you can use the following formula. On the Format menu click Style and then verify that the default font is correctly set to Arial 10. In a new Excel workbook select cell A1.
Add a new unit You can add different units of measurement to the list of available distance angular area location and direction units.
Easily switch cell size to inchescmmmpixels with Kutools for Excel 1. Select Home ribbon and then Format - Row heightcolumn width settings and they will be in actual length measurement units of inches. Change Column Width or Row Height to Inches in Excel We will go to File and then select Options Figure 2 Convert column width to inches In. You can change and define this unit manually where pointed in above link.