Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show current date in cell
Please can someone tell me how to format a cell to show current date each time a sheet is opened? thanks in advance -- Alex01 ------------------------------------------------------------------------ Alex01's Profile: http://www.excelforum.com/member.php...o&userid=26311 View this thread: http://www.excelforum.com/showthread...hreadid=516232 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show current date in cell
Put this in a cell:
=today() Give it a nice date format. Alex01 wrote: Please can someone tell me how to format a cell to show current date each time a sheet is opened? thanks in advance -- Alex01 ------------------------------------------------------------------------ Alex01's Profile: http://www.excelforum.com/member.php...o&userid=26311 View this thread: http://www.excelforum.com/showthread...hreadid=516232 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show current date in cell
In an un-used cell format as General and then enter:
=TODAY() -- Gary's Student "Alex01" wrote: Please can someone tell me how to format a cell to show current date each time a sheet is opened? thanks in advance -- Alex01 ------------------------------------------------------------------------ Alex01's Profile: http://www.excelforum.com/member.php...o&userid=26311 View this thread: http://www.excelforum.com/showthread...hreadid=516232 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show current date in cell
thank for your replies. sorry i've started another thread. Is it possible to do this with date and time please? alex -- Alex01 ------------------------------------------------------------------------ Alex01's Profile: http://www.excelforum.com/member.php...o&userid=26311 View this thread: http://www.excelforum.com/showthread...hreadid=516232 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show current date in cell
TRY THIS =now() this gives present date and time.. -- anu_manu ------------------------------------------------------------------------ anu_manu's Profile: http://www.excelforum.com/member.php...o&userid=31510 View this thread: http://www.excelforum.com/showthread...hreadid=516232 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if data in one cell, then date in adjacent cell | Excel Worksheet Functions | |||
Show week number in current month | Excel Discussion (Misc queries) | |||
How do I get a cell to show the day of the week when date entered | Excel Discussion (Misc queries) | |||
How do I show file creation date in a cell in Excel? | Excel Worksheet Functions | |||
Extracting data from the current date | Excel Worksheet Functions |