Right-click the sheet tab, select View code, enter this:
Private Sub Worksheet_Change(ByVal Target As Range)
If IsDate(Target.Resize(1, 1).Value) Then Target.Resize(1,
1).NumberFormat = "mmmm-dd"
End Sub

HTH
Bob Umlas,Excel MVP

"Jay" wrote:

Is there a method that would convert any Date entered into a cell whether
it's 06/01/05 or June-2005 or 06/01/2005 or any other entry to June-05 (and
still be a valid date) and not show-up as 06/01/05 in the formula bar, but as
June-05 instead?