Excel - Add a fixed date in a cell

Ask a question
  • 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.



Excel - Define and store constant values
Excel/VBA - A Find search with multiple return