Hi , I want to display the current timestamp for each entry into a column, however when I use =IF(B3 <> "",IF(A3="",NOW(),A3),"") I get 1/0/1900 and even though I changed the format cells option to custom date time , I get the same result. Please help, I want to know what is wrong.
Thanks!
Bookmarks