spreadsheet - Is it possible to insert date automatically in one cell in MS excel 2007 -

-

i have 1 excel document 2 columns. add text in 1 column on daily basis , want on second column current date , time automatically gets added.

that field can hidden , can when wanted want date time when added in row

is possible

try today() or now() function? return today's date. warned tomorrow if open spreadsheet cell show tomorrow's date. need have macro copy , paste values date cell.

i think other thing do, use keyboard shortcuts ctrl + ; or ctrl + : insert current date , time in active cell. since places value, don’t need worry if date or time changes. manual, , may or may not after.


Comments

Post a Comment

Popular posts from this blog

Delphi Wmi Query on a Remote Machine -

-
we use wmiset wmi queries on remote machines. works in delphi 2007 not available delphi xe. i found code wmi queries previous question use wmi delphi . code snippet provided in answer no. 5 works on local machine, need know if possible execute wmi query on remote machine. even if connect remote machine administrator credentials, eolesyserror: access denied exception. regards, pieter. pieter. before connect remote machine using wmi must enable dcom access specified user in remote machine. read these articles understand , fix problems connecting remote machines using wmi. securing remote wmi connection connecting wmi remotely starting windows vista troubleshooting error code 80070005 - access denied (great page find solution connections problems) additionally here leave more clear code connect wmi in remote machine. check part eoleexception exception processed error code , found cause of issue. program wmiremote; {$apptype console} uses sysutils,...
Read more