I think we were all confused by the OP's statement that he typed in the date.

CLR wrote:

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


--

Dave Peterson