A03 Format Data Values with the Format Bar 1:59

prev < Numbers ’09 > next

1
00:00:01,134 --> 00:00:03,236
Format data values with the format bar

2
00:00:03,236 --> 00:00:05,472
You can quickly set up cells so that they

3
00:00:05,472 --> 00:00:07,307
automatically add decimal points,

4
00:00:07,307 --> 00:00:10,343
dollar signs and other custom formatting.

5
00:00:10,343 --> 00:00:13,446
All the values in this column
represent prices,

6
00:00:13,446 --> 00:00:15,882
to quickly format another currency symbol

7
00:00:15,915 --> 00:00:18,051
select the column

8
00:00:18,051 --> 00:00:20,487
and click the currency button in the format bar.

9
00:00:21,855 --> 00:00:25,859
Notice that the decimal value is
automatically change to two places.

10
00:00:27,060 --> 00:00:29,896
The numbers in these cells
are shown in decimals

11
00:00:29,896 --> 00:00:32,866
but would be better represented
in percentages.

12
00:00:32,866 --> 00:00:35,602
To do that, just select
the entire row

13
00:00:35,602 --> 00:00:39,072
go to the format bar and click
on the "Percent" button.

14
00:00:39,072 --> 00:00:42,008
The numbers in the row are then
reformatted instantly.

15
00:00:43,443 --> 00:00:46,246
You can even design your own
custom numbers formats.

16
00:00:46,980 --> 00:00:50,216
These cells show Global Energy Cost savings

17
00:00:50,216 --> 00:00:52,419
but it's hard to understand at a first glance

18
00:00:52,419 --> 00:00:54,287
because of all the zeroes.

19
00:00:54,287 --> 00:00:55,889
To make this easier to read

20
00:00:55,889 --> 00:00:58,024
drag the cursor form the upper left cell

21
00:00:58,024 --> 00:01:00,727
to the lower right cell that
we intend to change.

22
00:01:01,061 --> 00:01:04,230
Then in the format bar
click the more format button

23
00:01:04,230 --> 00:01:05,498
and choose "Custom..."

24
00:01:06,766 --> 00:01:09,102
In the custom format window that appears

25
00:01:09,102 --> 00:01:11,071
first drag a currency symbol

26
00:01:11,071 --> 00:01:13,139
from the "Number & Text Elements" box

27
00:01:13,139 --> 00:01:15,175
to the format field above.

28
00:01:15,175 --> 00:01:18,478
Because all the extra zeros are
unnecessary for this table

29
00:01:18,478 --> 00:01:21,147
add the K scale symbol after the number

30
00:01:21,147 --> 00:01:24,350
and then change that scale
to symbol B for billions.

31
00:01:26,186 --> 00:01:29,522
And finally add the decimal fields
after the ... number.

32
00:01:30,490 --> 00:01:33,059
A small sample preview of your custom format

33
00:01:33,059 --> 00:01:36,229
would dynamically change
as you add more elements.

34
00:01:36,229 --> 00:01:37,997
When the numbers is the way you want it

35
00:01:37,997 --> 00:01:40,700
type in a name for the format
and click "OK".

36
00:01:42,469 --> 00:01:44,704
The data in the selected column is changed

37
00:01:44,704 --> 00:01:47,240
to match the new custom format.

38
00:01:47,240 --> 00:01:49,342
And since you save the custom format

39
00:01:49,342 --> 00:01:52,946
it can be applied again to another
column in a different spreadsheet

40
00:01:52,946 --> 00:01:55,682
using the more formats menu
in the format bar.

]

All videos are copyright by Apple Inc.; transcriptions, subtitles and translations are volunteer efforts by members of this wiki.