Editing Dates
 

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.

Editing Dates
 

Two options:
1. Precede your entry with an apostrophe (')
2. Format your cells as text before you enter data.

Regards,
Fred

"laceylee1027" wrote in message
...
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.

Editing Dates
 

Type an apostrophe first, then the date you want. So...
'March 2010
and it will stay.

You can also pre-format an entire column to Text format and auto-complete
will be ignored for that column.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


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

Editing Dates
 

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.