I have a spreadsheet that calculates portions of my paycheck (so I know what to expect). Part of it is to estimates the taxes I pay, then later, when I put in the true values, I have to punch 'em in with the decimal point. Is there a way for me to punch in a whole-number value (say 1000) and it is converted into a decimal value (in this case, change it into $10.00)

BTW, I have Excel version 2003.

__________________
Peter A.
The Big Guy

i'm a little confused on this. why not just format the appropriate cells that you are entering into as currency to begin with?

I already have the cells formated to be currency and at 2 decimal places. The thing is is that I just don't want to be hitting the decimal point. I just want to enter a number and have it automatically insert a decimal point.

You should be able to type in 10, hit enter, and it will enter the .00

You could use the following code in the worksheet change event to get what you want.


Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

If IsNumeric(Target.Value) = True Then
Application.EnableEvents = False
Target.Value = Target.Value / 100
Application.EnableEvents = False
End If

End Sub