Editing Dates

  • Thread starter Thread starter laceylee1027
  • Start date Start date
L

laceylee1027

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.
 
Two options:
1. Precede your entry with an apostrophe (')
2. Format your cells as text before you enter data.

Regards,
Fred
 
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.
 
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
 
Back
Top