Another possibility, which does not require the cell to be formatted, would
be...

=TEXT(28*A1,"mmmm")

--
Rick (MVP - Excel)


"Shane Devenshire" wrote in
message ...
Hi,

You've got a solution, but no one explained why your approach didn't work:

Excel stores dates as numbers starting with January 1, 1900 being day 1.
Each successive day is one number higher. So you got lucky with 1, but 2
is
January 2, 1900, so you didn't get February.

Here is another solution:

=--(A1&"-1")

Put this formula in A10 and format the cell to MMMM.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


" wrote:

I have one cell formatted as a number and I am trying to get it to
format to a different cell as mmmm and I need it to update everytime I
change the numerical cell.

Example:

A1 has 1 as number
A10 is referring to A1 with custom format of mmmm which returns
January.

My problem is that when I change A1 to 2 A10 does not update to show
February.

Please help... am I doing something wrong?

Thanks in advance.