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!

Assuming the "month" numbers are input in C1 down,
you could use something like this in say, D1, copied down:
=IF(OR(C1="",C112),"",VLOOKUP(C1,{1,"January";2," February";3,"March";4,"April";5,"May";6,"June";7," July";8,"August";9,"September";10,"October";11,"No vember";12,"December"},2,0))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik
---
"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!

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!

This should work...

=TEXT(28*A1,"mmmm")

where A1 contains your month number; of course, you could use the number, or
a calculation that results in the number, directly...

=TEXT(28*12,"mmmm")

Rick


"jordanpcpre" wrote in message
...
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!

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!

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!

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!

Just to point out, you can use either 28, 29 or 30 for the multiplier
constant... your choice.

Rick


"Rick Rothstein (MVP - VB)" wrote in
message ...
This should work...

=TEXT(28*A1,"mmmm")

where A1 contains your month number; of course, you could use the number,
or a calculation that results in the number, directly...

=TEXT(28*12,"mmmm")

Rick


"jordanpcpre" wrote in message
...
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!

On Jul 7, 9:17*am, "Rick Rothstein \(MVP - VB\)"
wrote:
Just to point out, you can use either 28, 29 or 30 for the multiplier
constant... your choice.

Rick

"Rick Rothstein (MVP - VB)" wrote in
. ..



This should work...

=TEXT(28*A1,"mmmm")

where A1 contains your month number; of course, you could use the number,
or a calculation that results in the number, directly...

=TEXT(28*12,"mmmm")

Rick

"jordanpcpre" wrote in message
...
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!- Hide quoted text -

- Show quoted text -

Although answered, another way of going about it is to use the choose
function

=choose(A1, "Jan", "Feb", "Mar",etc...) Therefore, if a 12 is
entered, the formula will look to the 12th label within and result in
Dec