Entering a dollar amount w/out having to enter the decimal

J

Julieanne

What is the formula to have Excel automatically enter the decimal so all I
have to enter is the numbers?
 
F

Fred Smith

It's one of the options you can specify. In Excel 2007, it's:
Excel Options...>Advanced>Automatically insert a decimal point

Regards,
Fred
 
Top