Entering Numbers with 2 Decimal Places - Automatically

  • Thread starter Thread starter Bruce
  • Start date Start date
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
 
Choose Tools>Options
On the Edit tab, add a check mark to Fixed Decimals
Set the number of places to 2
Click OK
 
Back
Top