embedded static time & date
 

How do I link this to my spreadsheet, it gives the current date and time

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

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

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