XL is converting what you have entered into an actual date that can be used
with all of the date type functions. There are 2 options.

1. Format the cells as text prior to entering the date. This way XL will not
do the conversion. What you see in the cell is just text.
Format - Format Cells... | Number | Text
2. Format the cells as teh date type that you want. The values in the cells
will be true dates.
Format - Format Cells... | Number | Custom | Mmmm d

--
HTH...

Jim Thomlinson


"TheRiverT" wrote:

I am trying to enter the date September 19 and I do not want the year tacked
on.
Everytime that I type "September 19" and press enter, Excel automatically
changes it to 19-Sep or when the cell is highlighted it is 9/19/09. How can I
turn off automatic formulas and editing and what not?