Check out Using the Numbers Convert Function at YouTube for closed captioning and more options.
Using the Numbers Convert Function
Comments: 5 Responses to “Using the Numbers Convert Function”
Comments Closed.
Check out Using the Numbers Convert Function at YouTube for closed captioning and more options.
As cool as the CONVERT function is, the custom formatting is nice, too. Thanks!
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
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.
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.
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.