Just use a custom format. Go to Format - Cells - Number - Custom then enter
mmmm.

" 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.