Excel - Add a fixed date in a cell

April 2018

  • 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.
This document, titled "Excel - Add a fixed date in a cell," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm.net/).
Excel - Define and store constant values
Excel/VBA - A Find search with multiple return