Discussion: Way OT: Excel
Afficher un message
Vieux 15/06/2008, 14h47   #3
kim
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: Way OT: Excel

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
>>

>
>
>


--
Kim
---------------------------
http://www.geekministry.com

  Réponse avec citation
 
Page generated in 0,06187 seconds with 9 queries