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
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