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.

Use this step-by-step guide to copy format in Excel worksheet columns and rows and improve your data presentation and organization.

When you type a seven-or-ten-digit phone number into an Excel cell that uses the phone number format, Excel will automatically change the way the number looks so that it appears as a phone number.

As a result, if you apply the Accounting number format to a whole column or row that contains text as well as financial values, remember to revert those non-numerical cells to the Text format.

You can stop Excel from rounding large numbers by changing the cell format from General to Number. This trick works for numbers containing 15 or less than 15 digits.