Prev: reduce size ribbon
Next: time calculations
From: laceylee1027 on 4 Mar 2010 17:14
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.
From: Fred Smith on 4 Mar 2010 17:23
Two options:
1. Precede your entry with an apostrophe (')
2. Format your cells as text before you enter data.

Regards,
Fred

"laceylee1027" <laceylee1027(a)discussions.microsoft.com> wrote in message
news:55D904A4-FA49-425F-9837-D1104229E750(a)microsoft.com...
> 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.

From: Queso hotmail com> kcrippstein on 4 Mar 2010 17:35
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.
From: FSt1 on 4 Mar 2010 17:38
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.
 | 
Pages: 1
Prev: reduce size ribbon
Next: time calculations