Confused
 

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?

Confused
 

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?