Another
Custom format the cell as as mmmm yy,
Not just type the month/year
1/9
===
or
format as mmmm "09" and just type
1

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Orrie" wrote in message
...
Hi,
I maintain a list of new members to a club, and enter the new list of
new members for each month. I just want to separate the new members
for each month by entering the month's name in a cell. This will not
be used in any calculations. So, each month I need to enter the name
of the month and the year as text, like this January 09 (or January
2009 would do as well.) But after I type it in and move to the next
cell, Excel 2003 switches the entry to this format: 9-Jan

How can get Excel to accept what I enter and treat as simply text, not
a value. It is not necessary to use the month and year in any
calculations.

Thank you.

Orrie