资讯

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 ...
Since Excel's primary function is to handle numerical data, the General number format displays numbers exactly as they are typed without any formatting.
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.