There are many ways of creating a date stamp or/and time stamp in Excel. You can check them e.g. in these pages:
In most cases - unless you need a time stamp which displays seconds - you can use Excel shortcuts for both date and time:
CTRL+SHIFT+: (colon) shortcut for your time stamp,
and CTRL+; (semicolon) shortcut for the date stamp.
These two shortcuts provide STATIC (non-refreshable) stamps; they are not updated whenever anything changes in your worksheet. The NOW() function is OK, but it inserts DYNAMIC (refreshable) stamp, so it requires conversion from function to a value format to become static.
|
