Changing Number Formats


There are numerous ways to express a number. A number can be expressed as a whole number, as a percent, as a fraction, as currency, as a date, and even exponentially. Google Spreadsheets employs a wide variety of number formats that you can apply to your data.

Table 5 details the number formats available in Google Spreadsheets; Table 6 details the percent formats; Table 7 details the date and time formats. Examples are included for each.

Table 5. Google Spreadsheets Number Formats

Number Format

Number Typed: 5000

Number Typed: 5

Number Typed: -5

Number Typed: .5

Plain Text

5000

5

-5

0.5

Normal

5000

5

-5

0.5

Rounded

5,000

5

-5

0

2 Decimals

5,000.00

5.00

-5.00

0.50

Financial Rounded

5,000

5

(5)

0

Financial

5,000.00

5.00

(5.00)

0.50

Dollar

$5,000

$5

-$5

$0

Dollar and Cents

$5,000.00

$5.00

-$5.00

$0.50


Table 6. Google Spreadsheets Percent Formats

Number Format

Number Typed: 5

Number Typed: .5

Number Typed: .005

Number Typed: -.5

Percent Rounded

500%

50%

0%

-50%

Percent

500.00%

50.00%

0.50%

-50.00%


Table 7. Google Spreadsheets Date and Time Formats.

Number Format

Example

Date (1)

2/14/2006

Date (2)

14-Feb-2006

Time

2:45:30

Date Time

2/14/2006 2:45:30


Note

The difference between the plain text and normal formats is in the alignment. The plain text format is left aligned; the normal format, as with all the other number formats, is right aligned.


Google Spreadsheets applies the Normal number format by default when you enter numbers into your worksheet. You can, however, apply any number format to any particular cell. To apply a different number format, follow these steps:

1.

Select the Format tab.

2.

Select the cell or range.

3.

Click the Choose Format button.

4.

Choose the number format from the list, as shown in Figure 29.

Figure 29. Choosing a number format.





Using Google Spreadsheets
Using Google Spreadsheets
ISBN: B000P28WL2
EAN: N/A
Year: 2007
Pages: 78

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net