Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Alex01
 
Posts: n/a
Default current Date and time in cell


Further to my last post
http://www.excelforum.com/showthread...ight=show+time
Is it possible to show current date and time when sheet is opened
please?

thanks in advance

alex


--
Alex01
------------------------------------------------------------------------
Alex01's Profile: http://www.excelforum.com/member.php...o&userid=26311
View this thread: http://www.excelforum.com/showthread...hreadid=516280

  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default current Date and time in cell

=now()
format as date and time.

This will update whenever excel recalculates.

Alex01 wrote:

Further to my last post
http://www.excelforum.com/showthread...ight=show+time
Is it possible to show current date and time when sheet is opened
please?

thanks in advance

alex

--
Alex01
------------------------------------------------------------------------
Alex01's Profile: http://www.excelforum.com/member.php...o&userid=26311
View this thread: http://www.excelforum.com/showthread...hreadid=516280


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default current Date and time in cell

Put the folowing macro in This Workbook code:


Private Sub Workbook_Open()
Sheets("Sheet1").Activate
Cells(1, 1).Formula = "=NOW()"
Cells(1, 1).Value = Cells(1, 1).Value
End Sub

Everytime you open the workbook, cell A1 in Sheet1 will be time/date marked.
--
Gary''s Student


"Alex01" wrote:


Further to my last post
http://www.excelforum.com/showthread...ight=show+time
Is it possible to show current date and time when sheet is opened
please?

thanks in advance

alex


--
Alex01
------------------------------------------------------------------------
Alex01's Profile: http://www.excelforum.com/member.php...o&userid=26311
View this thread: http://www.excelforum.com/showthread...hreadid=516280


  #4   Report Post  
Posted to microsoft.public.excel.misc
Alex01
 
Posts: n/a
Default current Date and time in cell


many thanks for your valued advice.

alex


--
Alex01
------------------------------------------------------------------------
Alex01's Profile: http://www.excelforum.com/member.php...o&userid=26311
View this thread: http://www.excelforum.com/showthread...hreadid=516280

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I insert the current time (static) and date in a cell? DF Excel Discussion (Misc queries) 5 October 28th 05 05:54 PM
Combined date time cell to separate date & time components Mark Ada Excel Discussion (Misc queries) 1 December 2nd 04 03:48 AM
Combined date time cell to separate date & time components Mark Ada Excel Discussion (Misc queries) 1 December 2nd 04 01:07 AM
Combined date time cell to separate date & time components Mark Ada Excel Discussion (Misc queries) 1 December 2nd 04 01:07 AM
Combined date time cell to separate date & time components Mark Ada Excel Worksheet Functions 1 December 2nd 04 01:04 AM


All times are GMT +1. The time now is 11:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"