Thread: Show a month as Aug, Sep etc
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jock Jock is offline
external usenet poster
  
Posts: 440
Default Show a month as Aug, Sep etc
With a date in A1, '=MONTH(A1)' in B1, how do I change the numeric result in
B1 to Text perhaps in C1?
So
A1 B1 (C1)
09/08/07 8 (Aug)
--
tia

Jock
Reply With QuoteReply With Quote