Set the Decimal Place

> Articles

Microsoft Windows
Microsoft Word
Microsoft Outlook
Microsoft Excel
Microsoft PowerPoint
Microsoft FrontPage
Palm OS
General Articles

Microsoft Excel

Print article

E-mail this page

Reader rating: 6 out of 10

Introduction

When you type: 5.00 in Excel, it is automatically changed to: 5. But what if you want to keep the two zeros after the decimal point?

This How-To Article shows you how to set the decimal place in Excel.

Set the Decimal Place

1. Click the cell which you would like to change the decimal places for. (Or, highlight more than one cell to apply this option to multiple cells.)

2. Click the Format menu and select "Cells...".

3. Click the "Number" tab.

4. From the "Category:" list, select "Number".

5. In the "Decimal places:" text box, enter the number of decimal places you would like Excel to keep.

6. Click OK.

Rate this article:

Poor 1 - 2 - 3 - 4 - 5 - 6 - 7 - 8 - 9 - 10 Excellent

Books on Microsoft Excel

Featured articles

Choosing a Cell Phone and Rate Plan - General Articles

Stopping Unwanted E-mail - General Articles

Learn about Cookies - Microsoft Windows

HotSync Timeout Errors - Palm OS

Also from Computertim Technologies

Thoughts on Internet Advertising - an interactive opinion essay by Tim Rooney.

Post your opinions on technology and get free computer help in the forums.

Tired of AOL? Try Juno for half the price of AOL.

Shop for the best deals online at our shopping site.