Percentage Multiplies by 100

  • Thread starter Thread starter novicevbaer
  • Start date Start date
N

novicevbaer

Does anyone offhand know the special formatting so that Excel will no
multiply the entered percentage by 100? I have a user form where
percentage is entered and it puts it into a cell.

If the user enters 4.....400% is placed into the cell instead of 4%

Thanks in advance for hel
 
One way. Right click sheet tab>view code>insert this.Save.
Now any number you put in col B below row 2 will be a percentage
ie 5 =5.00%

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row > 2 And Target.Column = 2 Then
Application.EnableEvents = False
Target = Format(Target / 100, "00.00%")
Application.EnableEvents = True
End If
End Sub
 
Tools>Options>Edit, check " Enable automatic percent entry"

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Back
Top