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!