Excel auto date

Author

Excel auto date

shaxx
Junior Member

Registered: Dec 2000
Location: NC
Country:
State:
Certifications:
Working on:

Total Posts: 25

Excel auto date

Is there a way to set a cell in excel to automatically enter the current date. There has to be a way but I don't know how.

Thanks,

shax

Report this post to a moderator

01-23-02 03:27 PM

Click here to Send shaxx a Private Message

IP: Logged

mlstyles
Junior Member
M

Registered: Nov 2001
Location: Atlanta
Country: United States
State:
Certifications: MOUS Master Instructor Office XP, 2000 & 97, Microsoft Certified Professional, A+, Network+, IC3
Working on: I ran out of things that interest me. Anyone know of a Crystal Reports cert?

Total Posts: 27

Do you mean besides =Today() or =NOW() ?

Report this post to a moderator

01-23-02 04:40 PM

Click here to Send mlstyles a Private Message

IP: Logged

shaxx
Junior Member

Registered: Dec 2000
Location: NC
Country:
State:
Certifications:
Working on:

Total Posts: 25

Thanks

Thanks, that's exactly what i needed.

Report this post to a moderator

01-23-02 05:14 PM

IP: Logged

vinnyg101
Member

Registered: May 2001
Location: King of Prussia
Country: United States
State:
Certifications: None
Working on: A+, Net +, MCDBA

Total Posts: 51

Making the date unchangeable

This is good info. I have a follow up to these questions.

Let's say that you use the =Time() or =Now(). Then Excel will record the time or date,time accordingly.

But if you open the workbook the next day won't the time or date change?

How can you make the time or date unchanging. I use these to formulas to keep track of data once it has been entered into a cell. I need to know when the data was enter for my supervisors log.

Report this post to a moderator

02-02-02 12:34 AM

Click here to Send vinnyg101 a Private Message

IP: Logged

I thought the original purpose was to make the date/time update. Anyhow:

to insert the current date into a cell, use CTRL + ; (semicolon)
to insert the current time into a cell, use CTRL + SHIFT + ; (semicolon)
so, to insert both the current date and time into a cell:
1) use CTRL + ; (semicolon)
2) skip a space
3) then use CTRL + SHIFT + ; (semicolon)

These are all static dates/times and will not update.

Report this post to a moderator

02-02-02 01:19 AM

IP: Logged