auto decimal in currency
 

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.

auto decimal in currency
 

ToolsOptionsEdit.

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


On Tue, 23 Oct 2007 20:52:00 -0700, mike6342
wrote:

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.