Using the Numbers Convert Function

You can use CONVERT to convert numbers from one unit to another. Convert distances from meters to feet, temperatures from Fahrenheit to Celsius, and so on. You can also use cell formatting to attach unit symbols to numbers.

Comments: 5 Responses to “Using the Numbers Convert Function”

    2 years ago

    As cool as the CONVERT function is, the custom formatting is nice, too. Thanks!

    2 years ago

    on meters to feet what formula can i use to show meters to feet + inches
    first cell you had 328.08 feet so how do i show instead on .08 of a foot
    328 feet 1 inch

    2 years ago

    David: There’s no simple way to do that. You can create a complex formula to pull out the integer and the decimal and then add the strings feet and inches, and then place that in another column. Then hide the initial column.

    Jacques Levy
    2 years ago

    The speaker slurred a word in the instructions for accessing the conversion function, so I could not completely follow the example. In the example provided, he began to show how to convert distance in meters to distance in feet. Then he said, “hit the ??????? key…and then convert…” Which key is it that permits access to the conversion function? In general this speaker does not enunciate many words, reducing the effectiveness of his presentation.

    2 years ago

    Jacques: The speaker? You mean me? Sorry about that. I just try to be myself when making these videos and sometime my enthusiasm means I talk too fast. That’s one of the reasons I include a transcript under the video.
    You can begin entering in formulas in Numbers many different ways. I prefer to hit the equals (=) key and then start typing the formula — that is what I believe you are looking for here.

Comments Closed.