Require Formula

[Closed]
Report
Posts
1
Registration date
Friday December 13, 2013
Status
Member
Last seen
December 13, 2013
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
I want to type only 1 in excel cell but require to come 100 and the same that 2 for 200, 3 for 300, 10for 1000, 50 for 5000, 100 for 10000 and so on. Please inform the formulas

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
suppose you are entering data in column A sheet 1 which you want to change to multiplied by 100.

rightlclick the tab of sheet and click view code.
in the resulting window copy this EVENT CODE


Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 1 Then GoTo enableevents 'modify if necessary
On Error GoTo enableevents
Application.enableevents = False
Target = Target * 100
enableevents:
Application.enableevents = True
End Sub