Excel

How to Format a Date in Excel

How to Format a Date in Excel

There are a few different ways to format a date in Excel. The most common way is to use the short date format, which is mm/dd/yy. To use the short date format, type the date in the cell and then press Ctrl+1. The shortcut key for the short date format is DD/MM/YYYY. To use the long date format, type the date in the cell and then press Ctrl+SHIFT+1. The shortcut key for the long date format is YYYY-MM-DD.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.