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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Mail Merge Switch - Dollars to Words 0
Mail Merge - displaying a conditional number of decimals 5
Autonumber field in Excel that behaves the same as Access 0
convert time to decimal 2
Convert number to text as displayed 4
Inserting decimal places 1
converting number to dollar 10

Top