Confused

[Guest]

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?

 

[Guest]

In B1: =A1 (custom format as mmmm)

 

[Guest]

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

 

[Guest]

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.

 

[David Biddulph]

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.