Thanks. As it turns out, you can use either 28, 29 or 30 for the multiplier
constant.

Rick


"TomPl" wrote in message
...
That is very clever. Good job!

Tom

"Rick Rothstein (MVP - VB)" wrote:

As it turns out, you can save the function call and just use this...

=28*A1

where A1 contains the month number, or you can use this..

=28*12

where you would use whatever the number is in place of the 12, then use
your
'mmmm' custom format.

Rick


"TomPl" wrote in message
...
You could use the formula =month(1900,12,1) then do a custom format on
the
cells with the formula of mmmm. That works for me.

Tom

"jordanpcpre" wrote:

Is there a way to use the month function so that if 12 is inputed,
December
will be the output? Rather than the reverse. I tried

=Month(12)

but that doesn't return December. Could you help me please?! Thanks!