(Grumbles)
I have gone into the "Tools" tab and in the "AutoCorrect Options,"
"Customize," and "Options" sections and turned off every autocorrect and
autoformat feature I can find. Yet Excel STILL tries to figure out the
formats for the next cell I enter data into. How do you stop Excel from
doing this? (It's pretty lousy and guessing what I want.) Thank you!

Have you tried Tools>Options>Edit.....uncheck "extend data range formats and
formulas"?


Gord Dibben MS Excel MVP

On Thu, 30 Mar 2006 07:26:02 -0800, topsquark
<(E-Mail Removed)> wrote:

>(Grumbles)
>I have gone into the "Tools" tab and in the "AutoCorrect Options,"
>"Customize," and "Options" sections and turned off every autocorrect and
>autoformat feature I can find. Yet Excel STILL tries to figure out the
>formats for the next cell I enter data into. How do you stop Excel from
>doing this? (It's pretty lousy and guessing what I want.) Thank you!

Ooooh! No, I didn't notice that one. Thank you!


"Gord Dibben" wrote:

> Have you tried Tools>Options>Edit.....uncheck "extend data range formats and
> formulas"?
>
>
> Gord Dibben MS Excel MVP
>
> On Thu, 30 Mar 2006 07:26:02 -0800, topsquark
> <(E-Mail Removed)> wrote:
>
> >(Grumbles)
> >I have gone into the "Tools" tab and in the "AutoCorrect Options,"
> >"Customize," and "Options" sections and turned off every autocorrect and
> >autoformat feature I can find. Yet Excel STILL tries to figure out the
> >formats for the next cell I enter data into. How do you stop Excel from
> >doing this? (It's pretty lousy and guessing what I want.) Thank you!
>
>