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?