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.

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

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

Set the column data format to "General," and then click the "Destination" icon to specify in which cells the numbers should appear, or use the defaults.

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.