Nuacht

If you are unable to change the date format in Excel, check the cell format, you need to change the cell format. This post will help you do that.
You can change the date & time format in Google Sheets & Excel Online using this guide. Use different date & time formats in spreadsheets.
It's easy to change the date format in Microsoft Excel. You just need to use the "Date" drop-down menu, which gives you plenty of options.
How to Change to Accounting Format in Excel. The accounting format in Microsoft Excel 2010 is very similar to the currency format---both display the currency symbol next to every number.
Image: 200dgr/Shutterstock The article, Use a custom format in Excel to display easier to read millions uses a custom format to make large values more readable. For instance, 1,200,000 displays as ...