auto decimal in currency

G

Guest

how do i get a result value of 12.34 if i input 1234 ?
I work with a large amount of currency values and I dont want to have to
type in the decimal each time.
 
G

Gord Dibben

Tools>Options>Edit.

Check "Fixed Decimal Places" and set to 2 using spinner.

Note: this is an Excel global setting and will affect all workbooks.


Gord Dibben MS Excel MVP
 

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

Inserting decimal places 1
Value trouble!!! 2
IF formula for currency or Macro help. 0
Formatting fields with decimal places 3
Decimal point in general format 1
Summary of Unique item values 2
VBA to insert currency 3
defined cell as currency but still have to enter decimal point 2

Top