Excel - Adding the current date in cell

December 2016





If you want to insert the current date in a cell in following format DD /MM/YYYY, and that it remains unchanged, without being updated each time the file is opened.
  • Select the cell and press "CTRL" + ";"
  • The same goes for, inserting the time in HH: MM:
  • Simply select the cell and press "CTRL" + ":"

Related :

This document entitled « Excel - Adding the current date in cell » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.