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.