hi
this is excel being helpful and not much you can do about it. if excel can
recognize it as a date, it slaps a format to it usually sumilar to what was
entered. if it can't recognize it as a date, it slaps an apostrophe in front
of it and boom, it's text.
so you can preceed your entry with an apostrophe but the date would be
considered text.
or you could create a custom format and preformat your entrees. (or post
format them) formats mar-10 and march-10 already exist so you would have to
crate march-2010.

probably not what you wanted to hear.
regards
FSt1

"laceylee1027" wrote:

When I enter March 2010 into excel it automatically changes it to Mar-10. I'd
like it to stay the way I originally typed it in. I already tried unchecking
the autocomplete in the advanced options but it didn't work.