date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

amir - 07 Nov 2007 06:53 GMT

how to set the date to appear Automaticaly, when i open excel

Reply to this Message

Gordon - 07 Nov 2007 08:13 GMT

> how to set the date to appear Automaticaly, when i open excel

Appear WHERE?

Reply to this Message

amir - 07 Nov 2007 09:29 GMT

i want the date to appear Automaticaly,in a cell when i open excel

> > how to set the date to appear Automaticaly, when i open excel
>
> Appear WHERE?

Reply to this Message

David Biddulph - 07 Nov 2007 09:58 GMT

=TODAY()

Signature

David Biddulph

>i want the date to appear Automaticaly,in a cell when i open excel
>
>> > how to set the date to appear Automaticaly, when i open excel
>>
>> Appear WHERE?

Reply to this Message

amir - 07 Nov 2007 13:57 GMT

yes, but i have to type that code every time i open excel.What i really want
to know is there a way that, once i set the date it has to update
automaticaly and appear in a cell when i open excel.

> =TODAY()
> >i want the date to appear Automaticaly,in a cell when i open excel
> >
> >> > how to set the date to appear Automaticaly, when i open excel
> >>
> >> Appear WHERE?

Reply to this Message

David Biddulph - 07 Nov 2007 14:43 GMT

If you put =TODAY() in a cell, then whenever you open the spreadsheet, the
date will appear in that cell and be updated.

Signature

David Biddulph

> yes, but i have to type that code every time i open excel.What i really
> want
[quoted text clipped - 7 lines]
>> >>
>> >> Appear WHERE?

Reply to this Message

amir - 07 Nov 2007 15:01 GMT

atlast....thanks

> If you put =TODAY() in a cell, then whenever you open the spreadsheet, the
> date will appear in that cell and be updated.
[quoted text clipped - 9 lines]
> >> >>
> >> >> Appear WHERE?

Reply to this Message

Gordon - 07 Nov 2007 15:03 GMT

> atlast....thanks

But you have to SAVE that sheet and open that one - if you open a NEW sheet
then it WON'T have the date in it...

Reply to this Message

Rate this thread: