Help with Drop downs

[SlurpeeD]

Hello I have a sheet that has a drop down. I want the drop downs to have options like 1. Annual Leave, 2. Sick Leave, 3. Holiday Leave and so on. When clicking on the drop down I want to be able to see the number and the text but when one is selected I only want to be able to see the number. is that possible?

 

[Skyybot]

Are you okay with using VBA Macros?

 

[Micron]

What kind of "drop down" is this? Validation list? Forms control? ActiveX control? If the latter, on a userform?

 

[Skyybot]

What kind of "drop down" is this? Validation list? Forms control? ActiveX control? If the latter, on a userform?

Yeah, I should've asked that. I assumed it was Validation drop down.

 

[Skyybot]

Yeah, I should've asked that. I assumed it was Validation drop down.

If is a Validation drop down and you're okay with VBA. Put this in the Sheet with the Drop down.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Validation.Value = True Then
    Target.Value = Left(Target.Value, 1)
End If
End Sub