Forum Discussion
date and time to automatically update
i have now() formula in excel. time and date is not changing to reflect the current time
The result of =NOW() will be updated whenever Excel recalculates formulas. You can force it to do so by pressing F9.
If you'd like Excel to act like a clock, that would require VBA code, but I would not recommend going that way - it has undesirable side effects.