Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I insert the current time (static) and date in a cell? | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Worksheet Functions |