Fix an Excel CONVERT Formula That Works in Only One Cell
Question details
The user needs an Excel CONVERT formula to recalculate in other cells when it is copied or source values change.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- A CONVERT formula is copied down a worksheet to convert values in multiple rows.
- Observed behavior
- The formula appears to work only in the first cell, and other results may not update automatically.
Open the affected workbook in Excel for Mac and identify the original CONVERT formula and the cells to which it was copied. Check that the source cells contain numbers and that the conversion units are valid.
Enable automatic calculation in Excel for Mac
Use this solution if copied formulas or changed source values are not recalculated automatically.
In Excel for Mac, select Excel > Preferences > Calculation. In some versions, Preferences may be labeled Settings.
Under Calculation, select Automatically, then close the settings window.
Press F9 to recalculate the workbook; on some Macs, press Fn+F9. Change a source value or copy the CONVERT formula down again and check the results.

Check copied CONVERT formulas and cell references
Use this solution if calculation is automatic but copied cells still show unexpected results.
Work with conversion formulas in WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format compatibility, making it easy to move existing workbooks. It does not change Excel's calculation settings.

Frequently Asked Questions
Where is the automatic calculation setting in Excel for Mac?
Go to Excel > Preferences > Calculation and select Automatically. In some versions, the menu uses Settings instead of Preferences.
How do I recalculate the workbook manually?
Press F9 in Excel. If your Mac uses special functions on the function keys, try Fn+F9.
Why do copied CONVERT formulas show the same result?
Select a copied cell and inspect its formula bar. A reference such as $A$2 stays fixed when copied; use a relative reference such as A2 if each row should refer to a different source cell.
What should I check if CONVERT returns an error?
Select the formula cell and check that the source value is numeric and that both unit abbreviations are valid and belong to compatible measurement types.




