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.

Tips More complex default value setting requires Excel Macro scripts to be written, for example, setting a different default value depending on the value of other columns in the spreadsheet.

Select the target sheet (s) — the sheets you want to update — by pressing [Ctrl] and clicking each sheet tab. Select Page Setup from the File menu and click OK. That’s it.