Wednesday, May 25, 2011

How to Format Numbers in Excel 2003


1. Open your Excel worksheet and select a group of cells. Press the left mouse button and drag over the cells.
2. Click 'Format' on the top menu bar. A list of options for formatting your worksheet will appear.
3. Click on the 'Cells' option. This will open a window of tabbed options for formatting cells.
4. Click on the 'Numbers' tab (it's the default tab). You will see a list of categories of numbers on the left and options for formatting them on the right.
5. Click on the category you want to format (Number, Currency, Accounting, etc.) and choose how you want these numbers to appear using the options provided on the right.
6. When you are done formatting, click 'OK.'

Blogger news