How do I link this to my spreadsheet, it gives the current date and time
J Jacob Skaria May 17, 2009 #2 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
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
J james May 17, 2009 #3 I dont need the current date & time, I need the date & time already formulated in the cell not to change. ?????
I dont need the current date & time, I need the date & time already formulated in the cell not to change. ?????
J Jacob Skaria May 17, 2009 #4 Please refer the below link for regarding using circular references and worksheet functions.. http://www.mcgimpsey.com/excel/timestamp.html
Please refer the below link for regarding using circular references and worksheet functions.. http://www.mcgimpsey.com/excel/timestamp.html
