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

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

For Excel to divide the values, however, the cell must contain a delimiter, a character that specifies where the first number ends and the second one begins.

Combine an Excel custom format with data validation and remove the pressure for input perfection from personnel by letting Excel do the work.

Learn how to highlight cells with negative values in Excel. Make negative numbers stand out in Red using Conditional or Custom Formatting.

How to subtract within a cell Just need to quickly subtract two numbers? You can do that within a single cell in an Excel spreadsheet. Step 1: In an Excel spreadsheet, click on an empty cell.

You may want to multiply cells or numbers in Microsoft Excel to analyze data. Here's what you need to know to do it.