D dlotz May 1, 2009 #1 is there a funciton that will return only the name of the month. IE COL A COL B 12/3/2009 December 3/4/2007 March and so on
is there a funciton that will return only the name of the month. IE COL A COL B 12/3/2009 December 3/4/2007 March and so on
N Niek Otten May 1, 2009 #2 Yes. Format the cell as Custom, in the Type box, enter "mmmm" (withour the quotes)
B Bob Umlas May 1, 2009 #3 in column B simply refer to column A and format col B as "mmmm" So B2 has =A2 and is formatted as "mmmm". Bob Umlas Excel MVP
in column B simply refer to column A and format col B as "mmmm" So B2 has =A2 and is formatted as "mmmm". Bob Umlas Excel MVP
G Glenn May 1, 2009 #4 is there a funciton that will return only the name of the month. IE COL A COL B 12/3/2009 December 3/4/2007 March and so on Click to expand... If you actually want the text "March" instead of a date formatted to show "March", use the TEXT() function: =TEXT(A1,"mmmm")
is there a funciton that will return only the name of the month. IE COL A COL B 12/3/2009 December 3/4/2007 March and so on Click to expand... If you actually want the text "March" instead of a date formatted to show "March", use the TEXT() function: =TEXT(A1,"mmmm")
