Entering Numbers with 2 Decimal Places - Automatically

[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

 

[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

 

[Bruce]

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

That was too easy.

Thanks much, Debra.
Bruce