A:A has dates in it, formatted as Date, dd-mm-yyyy
B:B I want to use =MONTH(A?). This works fine as it shows the month number,
ie 3. My problem starts when I try to format B:B as mmmm and the cell shows
January.
What am I doing wrong?

In B1: =A1 (custom format as mmmm)


"Dale" wrote:

A:A has dates in it, formatted as Date, dd-mm-yyyy
B:B I want to use =MONTH(A?). This works fine as it shows the month number,
ie 3. My problem starts when I try to format B:B as mmmm and the cell shows
January.
What am I doing wrong?

May be A1 is not a real date may be a text date, or B1 format as text.

"Dale" wrote:

Your suggestions works fine and I can work with this.
My confusion comes from the fact that the function MONTH(A1) does not work.
I was just wondering why.

"Toppers" wrote:

The previous answer given will get the correct result so if you have

in B1: =A1 and B1 formatted as "mmmm" then it's the data.

"Dale" wrote:

Did that, but it still shows January instead of March. Any thoughts?

"Teethless mama" wrote:

In B1: =A1 (custom format as mmmm)


"Dale" wrote:

A:A has dates in it, formatted as Date, dd-mm-yyyy
B:B I want to use =MONTH(A?). This works fine as it shows the month number,
ie 3. My problem starts when I try to format B:B as mmmm and the cell shows
January.
What am I doing wrong?

Your suggestions works fine and I can work with this.
My confusion comes from the fact that the function MONTH(A1) does not work.
I was just wondering why.

"Toppers" wrote:

The previous answer given will get the correct result so if you have

in B1: =A1 and B1 formatted as "mmmm" then it's the data.

"Dale" wrote:

Did that, but it still shows January instead of March. Any thoughts?

"Teethless mama" wrote:

In B1: =A1 (custom format as mmmm)


"Dale" wrote:

A:A has dates in it, formatted as Date, dd-mm-yyyy
B:B I want to use =MONTH(A?). This works fine as it shows the month number,
ie 3. My problem starts when I try to format B:B as mmmm and the cell shows
January.
What am I doing wrong?

If you have used MONTH(A1) to get the value 3, and then try to format that
cell as a date with the format mmmm, it will say January because number 3 is
the Excel equivalent of the date January 3rd 1900.

If you want just to show the name of the month, either format column A as
mmmm, or in B1 put =A1 and format B as mmmm.
--
David Biddulph

"Dale" wrote in message
...
A:A has dates in it, formatted as Date, dd-mm-yyyy
B:B I want to use =MONTH(A?). This works fine as it shows the month
number,
ie 3. My problem starts when I try to format B:B as mmmm and the cell
shows
January.
What am I doing wrong?