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.

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.

You can change the date & time format in Google Sheets & Excel Online using this guide. Use different date & time formats in spreadsheets.