How To Change Date Formats In Microsoft Excel
Excel uses the same date format as your computer’s system settings. You may want to change the format of the dates, though, to make it more accessible for users in other regions, or to make your data more compact. Change the Date Format To get started, open the Excel spreadsheet that contains the dates you want to reformat. Select the cells that hold each date by clicking and dragging your mouse over them....