MS Excel 97 - Number formats

This is not a course. It is a...

Tip Sheet

Number formats:

23	General
23.00	Number (2 decimal places)
R 23.00	Currency
R           23.00	Accounting
23-Jun-00	Date (23 June 2000)
0:00	Time
23.00%	Percentage
23 2/4	Fraction
2.30E+01	Scientific
23	Text
23-4567	Special (telephone number)

Select the cell(s) / column(s) / row(s) in which you wish to change the number format. Then...

Click on Format
Click on Cells

Choose the Number tab (it normally opens on that tab - see right)
Choose the number format by clicking on the name of the Category

Click OK