How to insert a date into an Excel spreadsheet?
For example, I have the formula
=NOW() but I want the date to be fixed as today's date. I don't want it to change tomorrow.
Is there a way to change the formula to make sure it only reflects the date today? Or how can I do that?
I don't want to Paste Special if possible.