Shane,

I thought I explained what was happening to the OP.

Anyway, your proposed solution doesn't work in the UK as we enter days
first and the "-" symbol is not normally used in dates.

Pete

On Feb 9, 5:38*pm, Shane Devenshire
wrote:
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.- Hide quoted text -

- Show quoted text -