The default active cell format in Microsoft Excel isn't all that easy to see, but you can use this easy-to-implement code solution to change that.

How to Make a Cell on Microsoft Excel With a Changing Date. Microsoft Excel offers a Function Library with formulas that insert the current date when you open the worksheet or enter calculations.