Entering Numbers with 2 Decimal Places

Entering Numbers with 2 Decimal Places - Automatically

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bruce - 17 Sep 2005 20:00 GMT

Hi,

I've been using Excel for years, yet this is my first time on this
newsgroup.

When reconciling my checkbook, I can set my 10-key calculator to 2 decimal
places, so that whenever I enter a number, it automatically converts it to
dollars and cents.

Is there a way to do this in Excel so that I don't have to hit the "." ?

Thanks,
Bruce

Reply to this Message

Debra Dalgleish - 17 Sep 2005 20:50 GMT

Choose Tools>Options
On the Edit tab, add a check mark to Fixed Decimals
Set the number of places to 2
Click OK

> Hi,
>
[quoted text clipped - 9 lines]
> Thanks,
> Bruce

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply to this Message

Bruce - 17 Sep 2005 21:48 GMT

> Choose Tools>Options
> On the Edit tab, add a check mark to Fixed Decimals
[quoted text clipped - 15 lines]
>> Thanks,
>> Bruce

That was too easy.

Thanks much, Debra.
Bruce

Reply to this Message