0
Thanks

A few words of thanks would be greatly appreciated.

Excel - Adding the current date in cell

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" + ":"
0
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
This document, titled « Excel - Adding the current date in cell », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).