How to turn off the automatic date feature in Excel 2003

If you enter a number that is formated like XXXX-XX-XX or
XX-XX-XX or XX-XX-XXXX ect. Excel automatically changes
the formating for the cell from "numbers, general"
to "numbers, date" you can reformat the cell but Excel
automatically loads a number that some how corresponds to
the date that it automatically entered. I would like to
turn OFF this feature. Excel 97 and 2000 do not do this.

There could be times when you want it so why not just format as text first
or use ' before entries

--
Don Guillett
SalesAid Software

wrote in message
...
If you enter a number that is formated like XXXX-XX-XX or
XX-XX-XX or XX-XX-XXXX ect. Excel automatically changes
the formating for the cell from "numbers, general"
to "numbers, date" you can reformat the cell but Excel
automatically loads a number that some how corresponds to
the date that it automatically entered. I would like to
turn OFF this feature. Excel 97 and 2000 do not do this.

wrote in news:09d901c3d9e0$c3516920
:

Excel automatically loads a number that some how corresponds to
the date that it automatically entered.

It's the number of days since Jan 1, 1900.

I would like to
turn OFF this feature. Excel 97 and 2000 do not do this.

My copy of Excel 2000 does this.

--
My email address has an extra @ (spell it out) and an extra invalid. Please
remove them if you are not a spammer or list broker and want to reply.

I am not sure when I would want this feature, but your
solutions do work. Thanks for the help.
-----Original Message-----
There could be times when you want it so why not just
format as text first
or use ' before entries

--
Don Guillett
SalesAid Software

wrote in message
...
If you enter a number that is formated like XXXX-XX-XX
or
XX-XX-XX or XX-XX-XXXX ect. Excel automatically changes
the formating for the cell from "numbers, general"
to "numbers, date" you can reformat the cell but Excel
automatically loads a number that some how corresponds
to
the date that it automatically entered. I would like to
turn OFF this feature. Excel 97 and 2000 do not do
this.


.

"Don Guillett" wrote...
There could be times when you want it . . .

OK, but there could be times when I want automatic or manual recalculation, but
Excel doesn't foist one but not the other on me. It's a mystery why Excel makes
it impossible to disable automatic formatting . . . unless you accept my own
theory that there's more than a little sadism in Excel's design.

--
To top-post is human, to bottom-post and snip is sublime.

I suspect that the last line of your statement is true but I want to say it
very softly.

--
Don Guillett
SalesAid Software

"Harlan Grove" wrote in message
...
"Don Guillett" wrote...
There could be times when you want it . . .

OK, but there could be times when I want automatic or manual
recalculation, but
Excel doesn't foist one but not the other on me. It's a mystery why Excel
makes
it impossible to disable automatic formatting . . . unless you accept my
own
theory that there's more than a little sadism in Excel's design.

--
To top-post is human, to bottom-post and snip is sublime.

Hi Harlan!

"unless you accept my own theory that there's more than a little
sadism in Excel's design"

My theory is that they have a Pythonesque humour which goes a bit
beyond sadism. How else do you explain the infliction of "Clippy" on
us and then (in first version) make it so difficult to get rid of it.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

"Norman Harker" wrote...
...
My theory is that they have a Pythonesque humour which goes a bit
beyond sadism. How else do you explain the infliction of "Clippy" on
us and then (in first version) make it so difficult to get rid of it.
...

If there were a sense of humor behind it, you could be right.

It wasn't so difficult to get rid of - all it took was deleting the files that
provided the pesonas. I can't remember their extensions because it's been so
long since I purged 'em.

--
To top-post is human, to bottom-post and snip is sublime.

But, the girls think he is cute & sexy. Wish they like me like that.

--
Don Guillett
SalesAid Software

"Norman Harker" wrote in message
...
Hi Harlan!

"unless you accept my own theory that there's more than a little
sadism in Excel's design"

My theory is that they have a Pythonesque humour which goes a bit
beyond sadism. How else do you explain the infliction of "Clippy" on
us and then (in first version) make it so difficult to get rid of it.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.