
Microsoft
Excel is a software that allows you to create efficient spreadsheets for business of personal use. They permit you to stay organized while managing large amounts of data, which can be organized in a range of ways.
One popular way to organize this data is by date. Excel comes with a default date format, mm/dd/yyy, but you can always choose to
change the date format, to dd/mm/yyy, for example.
Change Excel Date Format from mm/dd/yyyy to dd/mm/yyyy
To change the date display in Excel, go to
Format Cells >
Custom, and enter
dd/
mm/
yyyy in the available space.
The dates listed in your spreadsheet should be converted to the new format.
Image: © Microsoft.
Published by
owilson.
Latest update on February 18, 2018 at 11:40 AM by owilson.