If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
How to turn off the automatic date feature in Excel 2003
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. |
#3
|
|||
|
|||
How to turn off the automatic date feature in Excel 2003
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. |
#4
|
|||
|
|||
How to turn off the automatic date feature in Excel 2003
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. . |
#5
|
|||
|
|||
How to turn off the automatic date feature in Excel 2003
"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. |
#6
|
|||
|
|||
How to turn off the automatic date feature in Excel 2003
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. |
#7
|
|||
|
|||
How to turn off the automatic date feature in Excel 2003
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. |
#8
|
|||
|
|||
How to turn off the automatic date feature in Excel 2003
"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. |
Thread Tools | |
Display Modes | |
|
|