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.

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

The default active cell format in Microsoft Excel isn't all that easy to see, but you can use this easy-to-implement code solution to change that.