Formatting a cell to Display MONTH ONLY

[Mister H]

Hi All:

Hopefully this is an easy one. I am trying to format a cell so that it will display the month (Full Name) after the person gets out of the cell.

I want the user to enter 1 to 12 and then have the Alpha of that month displayed whern they exit the cell. I can get it to Display the month but ionly if I type the year as well.

If the user type a 6 or 06 I want that cell to display June when they exit it.

Any suggestions?

THANKS,
Mark

 

[Mister H]

Hi tmcfadden:

SORRY about that... Hopefully no permanent damage is done. I suppose when looking back on the Post it was YOU that steered the board in the right direction by explaining that the Normal Formatting would not work in this case. YOU were the first to write a code to get this going and BruceyBonu$ altered it to get it to perform as I needed. So in hindsight I guess I owe you a BIG THANKS as well. Hope this helps to get your day started in a good way and that you didn't lose too much sleep last night.

THANKS to ALL who helped in resolving my problem...

Have a GREAT weekend,
Mark