Welcome to Lockergnome.com!
HomeHome FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log in/Register/PasswordLog in/Register/Password

auto date

  
   Home -> Office -> New Users RSS
Next:  New Users: text string  
Author Message
Andy JL

External


Since: Nov 14, 2005
Posts: 12



(Msg. 1) Posted: Fri Nov 18, 2005 8:21 am
Post subject: auto date
Archived from groups: microsoft>public>excel>newusers (more info?)
Is it possible to have a cell i.e F14 - auto date with the days current date
when you open the template?

Andy JL
Back to top
Login to vote
galimi

External


Since: Jan 25, 2005
Posts: 17



(Msg. 2) Posted: Fri Nov 18, 2005 8:27 am
Post subject: RE: auto date [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Put =now() into the cell.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"Andy JL" wrote:

> Is it possible to have a cell i.e F14 - auto date with the days current date
> when you open the template?
>
> Andy JL
Back to top
Login to vote
Andy JL

External


Since: Nov 14, 2005
Posts: 12



(Msg. 3) Posted: Fri Nov 18, 2005 8:28 am
Post subject: RE: auto date [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Thanks works great but can it have it display just date without the time?

Andy JL

"galimi" wrote:

> Put =now() into the cell.
> --
> http://HelpExcel.com
> 1-888-INGENIO
> 1-888-464-3646
> x0197758
>
>
> "Andy JL" wrote:
>
> > Is it possible to have a cell i.e F14 - auto date with the days current date
> > when you open the template?
> >
> > Andy JL
Back to top
Login to vote
Gord Dibben

External


Since: Feb 23, 2004
Posts: 8800



(Msg. 4) Posted: Fri Nov 18, 2005 11:19 am
Post subject: Re: auto date [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Format the cell to whatever you want to see.

Cells>Format>Number>Date or Custom

Or use =TODAY()


Gord Dibben Excel MVP



On Fri, 18 Nov 2005 08:28:48 -0800, "Andy JL"
<AndyJL.TakeThisOut@discussions.microsoft.com> wrote:

>Thanks works great but can it have it display just date without the time?
>
>Andy JL
>
>"galimi" wrote:
>
>> Put =now() into the cell.
>> --
>> http://HelpExcel.com
>> 1-888-INGENIO
>> 1-888-464-3646
>> x0197758
>>
>>
>> "Andy JL" wrote:
>>
>> > Is it possible to have a cell i.e F14 - auto date with the days current date
>> > when you open the template?
>> >
>> > Andy JL
Back to top
Login to vote
car1304




Joined: May 09, 2008
Posts: 1



(Msg. 5) Posted: Fri May 09, 2008 8:01 am
Post subject: Re: RE: auto date [Login to view extended thread Info.]
How do you make the date and time remain as they were when entered using =now()?
Back to top
Login to vote
Display posts from previous:   
       Home -> Office -> New Users All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Categories:
 General
 Microsoft Windows XP
 Microsoft Windows Vista
 Microsoft Windows (other)
  Microsoft Office
 Microsoft Office (other)
 Computer Security
 Linux
 Movies

[ Contact us | Terms of Service/Privacy Policy ]