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

Using Excel's number format tool means you can ensure your spreadsheet both looks the part and handles your data exactly how you want it to.

If the Excel cell format is not changing to a number because the Number formatting is not working, take these steps to fix the issue.

Learn how to format & display Currency in Excel to display numbers as monetary values, by applying Currency or Accounting number format to cells.