How to Format Cell Numbers in Excel

By eHow Computers Editor

Rate: (2 Ratings)

You can change your Microsoft Excel numerical data to currency, dates, text and other formats. The following steps work with Excel 97.

Instructions

Difficulty: Moderately Easy

Things You’ll Need:

Step1
Open Microsoft Excel, then open the file you want to change.
Step2
Select the cells you want to format.
Step3
Open the Format menu and select Cells.
Step4
Click the Number tab.
Step5
Select a format type from the Category list. For example, for items in a budget, select Currency or Accounting. (A description of the selected format is displayed in the Format box to help you out.)
Step6
Click OK to accept the changes.

Tips & Warnings

  • To create a custom number format, click Custom in the list of formats, then enter codes to describe the format you want. (See Excel's online help for a description of number format codes.)
  • The Accounting format lines up decimal points and currency symbols in a column.

Post a Comment

POST A COMMENT

Request a New How-To Article

Looking for more How To information? Chances are there’s an eHow member who knows how to do what you’re looking to do. Submit an article request now!

eHow Article:  How to Format Cell Numbers in Excel

eHow Computers Editor

eHow Computers Editor

Category: Computers

Articles: See my other articles

Related Ads