How do I get Excel to stop auto-formatting?

G

Guest

(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!
 
G

Gord Dibben

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


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i stop autocorrecting the date? 2
Symbols added to Word's AutoCorrect don't appear in Excel 4
How do I stop auto conversion of numbers to a date? 2
how do i turn off auto fill? 3
How do I use the same Autocorrect options in word and excel 2
how do i restore symbol options to autocorrect? 3
how to get rid of hyperlinks when cutting and pasting e-mail addre 3
Is it possible to get Excel to stop formatting text as a date? 2

Top