Have you tried ToolsOptionsEdit.....uncheck "extend data range formats and
formulas"?


Gord Dibben MS Excel MVP

On Thu, 30 Mar 2006 07:26:02 -0800, topsquark
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!