date problems
Good Detective work Dave..........!
Vaya con Dios,
Chuck, CABGx3
"Dave Peterson" wrote:
You're not typing in those slashes, are you?
If you don't type in the slashes, then excel just sees it as a number:
111106 (111,106)
Typing 111106 in a cell and giving that cell a format of a date, just means that
you want the date that is 111,106 days after a base date (usually Dec 31, 1899
for wintel users).
If I type 111106 in a cell that's formatted as a date, I get 03/12/2204.
You've got to give excel some indication that you want a date.
piute wrote:
I see nothing in there . I tried a couple of things, but nothing has helped.
Every computer in this office is stand alone, and we all have the same
problem. I wonder if some upgrade the puter automatically does could affect
the spread sheet
"Dave Peterson" wrote:
One more guess...
Anything in your Autocorrect list that would affect this?
I still don't have a good idea.
piute wrote:
I did use excel/safe and opened the workbook and typed in the date 11/11/06
and it still comes up with 03/12/04 in the cell and on the formula bar it
says 3/12/2204
"Dave Peterson" wrote:
You say no macros, but I'd check.
Close excel
windows start button|Run
excel /safe
file|Open yourworkbook.xls
and test it out...
And do you get the same problem with every workbook?
piute wrote:
no file starts up and dont use macros
"CLR" wrote:
Is the difference always the same.........if you type in 11/11/06 does it
display 12/04/03, etc..........
Do yo have any file that starts up automatically when XL starts?.......if
so, perhaps a start-up macro is doing it?
hth
Vaya con Dios,
Chuck, CABGx3
"piute" wrote:
When I put in a date on the spread sheet, for instance 11/10/06 it comes out
12/03/03. In the formula bar, it say 12/03/2203. Excell worked fine a week
ago. I tried clearing the cell, went to format for date 11/11/06 is what I
want to use. I even opened a new spread sheet and the same thing happens.
My computer date is fine, dont know what else to check.
Any suggestions?
--
Dave Peterson
--
Dave Peterson
--
Dave Peterson
|