For the same reasons, values formatted with the Accounting number format are also right-aligned by default, though the currency symbol aligns to the left of the cell.

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 ...

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.

How to Change the Currency on iWork Numbers. The Numbers application that comes with Apple's iWork productivity suite is the equivalent to Microsoft's Excel application. As such, the application ...