| 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 | |||
Hybrid Mode
