embedded static time & date

[james]

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

 

[Jacob Skaria]

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

 

[james]

I dont need the current date & time, I need the date & time already
formulated in the cell not to change. ?????

 

[Jacob Skaria]

Please refer the below link for regarding using circular references and
worksheet functions..

http://www.mcgimpsey.com/excel/timestamp.html