Converting Serial Month Number to Text

RLSSP

New Member
Joined
Nov 7, 2005
Messages
7
I have a column that has the employees hire date. For example in cell A3 I have the hire date of 12/1/05 and in the column next to it I just want it to have the hire month for reporting purposes. So I used the formula =Month(A3) this returns the serial number for the month correctly. 12.... So then I do a custom format with the mmmm so it will say the month name and the only thing it will do is say January.

What am I doing wrong
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
Try this

=TEXT(MONTH(A3),"MMMM")

Edit:

Sorry: should have been =TEXT(A3,"MMMM") as suggested by Oaktree
 

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,988
Use the TEXT formula

=TEXT(A3, "mmmm") for January

or =TEXT(A3,"mmmm yyyy") for January 2005

You are formatting the number 12 as mmmm, which returns January.
 

Russ At Index

Well-known Member
Joined
Sep 23, 2002
Messages
670
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
  2. MacOS
Hi RLSSP , Welcome To The Board,

In cell A1 01/01/2005 ( Example )

Copy this into A2

=TEXT(A1,"mmm/yyyy")

HTH :)

Russ
 

sykes

Well-known Member
Joined
May 1, 2002
Messages
1,760
Office Version
  1. 365
Platform
  1. Windows
......... or just put:

= A3

in A4, then custom format A4 as mmmm.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,456
Messages
5,572,241
Members
412,450
Latest member
Heba
Top