In Microsoft Excel, you can convert a number into a fraction using the Fraction format. Learn how to display Numbers as Fractions in Excel.

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.

The date will display in the format you choose, no matter how you enter it. If you type "1/1/19" into a cell with the long date format, Excel will change it to the expanded date.

Learn how to format numbers in Thousands, Millions, and Billions in Excel and Google Sheets. Use number Formatting to convert numbers.

How to Format Fractions to Percentages in Excel. The cells in a Microsoft Excel spreadsheet can hold various types of numerical data, including fractions and percentages.