Thread: month formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Reggiee Reggiee is offline
external usenet poster
 
Posts: 10
Default month formula

Hi All

A question - if I type in the date 14/12/2004 and in the column next to it
use the month formula with the cell format set to general it correctly
returns 12. However if I want it to show say Dec I went to custom typed in
mmm and it always returns Jan.

Why is this and is there a better way to return the month description rather
than month number.

Thanks