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.

Select the cells that you want to format and then, in the Number group on the Home tab, click the down arrow in the Number Format box.Choose either Currency or Accounting.While both the Currency ...