| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
embedded static time & date
How do I link this to my spreadsheet, it gives the current date and time
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
embedded static time & date
For Date - press the CNTRL key and the ; key at the same time
For Time - press the CNTRL key, SHIFT key and the ; key at the same time If this post helps click Yes --------------- Jacob Skaria "james" wrote: How do I link this to my spreadsheet, it gives the current date and time |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
embedded static time & date
I dont need the current date & time, I need the date & time already
formulated in the cell not to change. ????? "Jacob Skaria" wrote: For Date - press the CNTRL key and the ; key at the same time For Time - press the CNTRL key, SHIFT key and the ; key at the same time If this post helps click Yes --------------- Jacob Skaria "james" wrote: How do I link this to my spreadsheet, it gives the current date and time |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
embedded static time & date
Please refer the below link for regarding using circular references and
worksheet functions.. http://www.mcgimpsey.com/excel/timestamp.html -- If this post helps click Yes --------------- Jacob Skaria "james" wrote: I dont need the current date & time, I need the date & time already formulated in the cell not to change. ????? "Jacob Skaria" wrote: For Date - press the CNTRL key and the ; key at the same time For Time - press the CNTRL key, SHIFT key and the ; key at the same time If this post helps click Yes --------------- Jacob Skaria "james" wrote: How do I link this to my spreadsheet, it gives the current date and time |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| static date and time | Excel Discussion (Misc queries) | |||
| Static Date & Time in Footer - Excel 2007 | Excel Discussion (Misc queries) | |||
| Static Date and Time code problem | Excel Discussion (Misc queries) | |||
| how can i set a static date and time in excel | Excel Worksheet Functions | |||
| how do I insert the current time (static) and date in a cell? | Excel Discussion (Misc queries) | |||
Linear Mode
