Excel - Add a fixed date in a cell
- If you want to insert the current date into a cell, using the DD/MM/YYYY format, and that it remains fixed (not updated each time you open the file - for example to indicate the date the file was created ):
- Select the cell and press "Ctrl" + ";"
- Under the same conditions, if you want to insert the current time in HH: MM format:
- Press "Ctrl" + ":" in the cell.
Published by jak58
Latest update on November 6, 2012 at 12:34 PM by jak58.