does anyone have an idea how to make “=now()” or “=today()” constant on excel. To be precise, when i use “now or today” on excel, the date keeps changing to the current time - and i don’t want that - what i want is for it to be constant. if “=now()” gives 2/4/2016 11:33:40 - i don’t want it to change a minute later.
you can enter … Ctrl ; … together in excel to give you a constant date also you can right click on a date entered with =now or =today and drag then drop back in cell … window pops up with options …click copy here as values only
ok tricky to explain but ill try … i am presuming you require the same date in all 700 cells if so you can do this
step 1 … say you are starting in cell A1 and going down to cell A700 … click on cell A1
step 2 … just above the cell (there will be a box showing the cell your in and it will say A1) click there … this will highlight the A1 in that box … click again and now your cursor is beside the Ai … now enter : a700 now hit enter … this will now select A1 to A700 in your excel sheet
step 3 … now hit f2 you will now have entered cell A1 and all other cells are still selected.
step 4 … now do Ctrl : this adds the date to the first cell (dont hit enter after you do this)
step 5 … Finally press Ctrl and Enter … this will fill all 700 cells with the date
Here is a link to the best online site for Excel … I love excel and learned so much from this site