ms excel 1

[ajyourpal]

Is there anyway to enter numbers with (2) decimal points without having to hit the decimal point key? For example, 12.45 requires to hit the decimal point key after the number 2.

Thanks

 

[SkipVought]

Hi,

Not directly. But you could have an adjacent formula...

=A2/100

You will need to format that column accordingly.

Hope this helps

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[Draig]

Here's another way.

Invoke Tools, Options, Edit and check the Fixed decimal check box. Make sure the spinner box next to it shows 2. Now, whenever you enter a number, a decimal point will be inserted before the last two digits.


Barborne
Worcester
UK

 

[SkipVought]

barborne,

That's a good answer.

But be advised, that this applies to ANY and ALL Excel workbooks/worksheets until you change that option again.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[JPMontreal]

Hi,

I know, it’s a little bit long but it seem to work, so you could try it. In the module of your sheet add:

Private varDe As Variant
Private addT As String

Private Sub Worksheet_Activate()
varDe = 0
addT = "A1"
End Sub

Private Sub Worksheet_Change(ByVal Target As Range)
If IsNumeric(Target.Value) Then
varDe = Target.Value
addT = Target.Address
End If
End Sub


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range(addT) = varDe / 100
End Sub



Jean-Paul
Montreal
jp@solutionsvba.com
mtljp2@sympatico.ca

 

[SkipVought]

Montreal,

This is the OFFICE Forum. We don't do coded solutions here unless there's not other good way.

That's what the VBA Forum is for

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com