You can turn off auto cell completion with this:

Tools > Options > Edit Tab and then clear the Enable AutoComplete for
cells option.

--

Virginia Carter
Carolina Web Creations
======================
www.carolinawebcreations.biz

kim wrote:
> Hi Tim,
>
> No. It's all dates in any .xls or .doc. I guess it has to do with the
> "assistant" that offers to finish the date and I use to press enter when
> this option occurs.
>
> What happens is this. I type a date in a spreadsheet (no macros or
> anything like that... just a date lets say when the xls/doc was created)
> or in a word document and save my file.
>
> If I then open this document/spreadsheet a month later the dates has
> changed to today's date... which is very inconvenient since I've no idea
> when the file was created! (well maybe there is an option when I can see
> this and then manually chage the date in the document... but I rather
> have the date didn't changed in the first place)
>
> Hope this made some sense
>
> Thanks
>
> TC2112 skrev:
>> Hi Kim,
>>
>> What date changes? Is it a specific cell in a worksheet, dates in a
>> range or all dates?
>> Did you create this workbook? If so, are there any macros, formulas or
>> conditional formatting attached to the date that changes?
>>
>> If it is a date in a cell(s) somewhere, and you can easily remove any
>> private data I'd be happy to take a look at it.
>> Just put it up and give the link.
>>
>> Take care,
>> Tim
>>
>>
>> "kim" <kim@removegeekministry.com> wrote in message
>> news:g32kdi$cdo$1@forums.macromedia.com...
>>> Hi,
>>>
>>> I'm sorry for this OT question... but I know someone knows what I
>>> need to do.
>>>
>>> My problem is that whenever I open an excel file created 6-8 month
>>> ago it changes the date to current date... and I DON*T WANT THAT. WTF
>>> was you thinking MS
>>>
>>> Anyway... is there a way I can turn this of?
>>>
>>> --
>>> Kim
>>> ---------------------------
>>> http://www.geekministry.com
>>>
>>
>>
>>
>