Thread: Show a month as Aug, Sep etc
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Show a month as Aug, Sep etc
Try,

Format cell with custom format of "mmm"
No quotes

Mike

"Jock" wrote:

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