I want to enter a number in a cell (ie: 25kph in cell B2) . I would like a formula to convert that number into mph and have the resulting answer appear in the same cell (ie : 15.5mph in cell B2) Is it possible please and if so what should I type as the formula?
Mac mini, 12.5
A cell can either be for user input or have a formula, not both. You can use an adjacent cell to do the conversion.
If you type 25 into cell B2 (not 25kph), the following formula in another cell will convert it to mph
=CONVERT(B2×1000,"m/h","mph")
With the formula below you could type "25kph" but really your could type "25abc" or "25 anything you like" and it will convert the 25 from kph to mph
=CONVERT(REGEX.EXTRACT(B2,"\d+")×1000,"m/h","mph")
Numbers Formula
