Entering fractions in Microsoft Excel isn’t exactly intuitive, but it is easy. Learn how to enter and display fractions as either fractions or as decimal values.

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 most obvious way to increment a number in Excel is to add a value to it. Start with any value in cell A1, and enter "=A1+1" in cell A2 to increment the starting value by one.

Instead, you might want Excel to display negative values in red, or with parentheses, or both. Microsoft Excel provides two ways to do so: a format and a conditional format.