This is not a course. It is a... Tip Sheet

COMPUTER SKILLS AND TIP SHEETS
MS Excel 2000 - Number formats

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

  numbrfrmt.jpg (20859 bytes)

                                           The Educators' Network



Copyright SchoolNet SA and SCOPE. All Rights Reserved.