Formatting numbers


show more Formatting numbers provides you with in-depth training on Business. Taught by David Rivers as part of the Numbers '09 Essential Training show less
please wait ...

Formatting numbers

Formatting the numbers in a table allows you to make better sense of the values being displayed. Let's use this version of our Running Club Data spreadsheet to explore some number formats. The values we see in each of the tables in this spreadsheet are kilometers. But we really wouldn't know this by looking at the values. Well, we can change numbers to another format. One option is to select the cells first. Let's click and drag over all of the cells containing numbers in our first table named Distance Run - Men. And let's change the format by using the Format bar. Here you will find some predefined formats like Percentage and Currency, for example.

The first button will display two decimal places. So let's select that one. Now you can see, each of the values has two decimal places. And in many cases numbers were entered using those decimal places. Some were not so we see 0s in those cells. Now we can also adjust the number of decimal places manually from the Forma...

Formatting numbers
Video duration: 6m 53s 3h 53m Beginner

Viewers:

Formatting numbers provides you with in-depth training on Business. Taught by David Rivers as part of the Numbers '09 Essential Training

Subject:
Business
Software:
Numbers
Author:
please wait ...