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?