Set automatic currancy decimal without entering the decimal?

G

Giesej

On calculators, one can set it for always placing a two place decimal.
Therefore, I do not have to to hit the decimal when adding a currancy column.
The two place decimal is automatic. If there is no cents, one enters 2 zeros.
Can the computer be set for that?
 
M

Mike H

Hi,

format the cell as currency and decimal places are automatically added or if
you don't want a currency format then use number and you get the same but
without the currency symbol.

Mike
 
S

Shane Devenshire

Hi,

Choose Tools, Options, Edit, and check Fixed decimal and leave 2 in the
Places box.
 

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

Top