Entering Numbers with 2 Decimal Places - Automatically

B

Bruce

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
 
D

Debra Dalgleish

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

Bruce

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

That was too easy.

Thanks much, Debra.
Bruce
 
Top