Month? Question:1=Jan.,2=Feb.,3=Mar.ect

[redd]

I would like to put in cell 1a, 1.Cell 1a would show Jan.,2=Feb.,7=Jul.ect.

 

[atmospheric]

Sorry Redd, can you give a bit more information?

 

[Scott Huish]

Perhaps:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Target = "" Then Exit Sub
If Target.Address <> "$A$1" Then Exit Sub
Application.EnableEvents = False
    Target = Format(DateSerial(1, Target, 1), "mmm")
Application.EnableEvents = True
End Sub

 

[PA HS Teacher]

If you want to use a formula.

=Choose(A1,"Jan","Feb","Mar",...)

 

[Nimrod]

=TEXT(A1*30,"mmmm")