Have you tried to enter a fraction into your Excel sheet, but when you press enter, it turns into a serial, whole, or decimal number, and you have no clue what to do? In Microsoft Excel, you can ...

Sometimes when I’m working with an Excel worksheet and I want a cell to look a certain way, I run into what appears to be a limitation in the program. It might be trying to enter product numbers with ...

To do this, with the 1% cell still copied, select the cells containing the values you want to convert from whole numbers into ...

Excel displays the original number up to 11 digits. When you enter a number that has more than 11 digits, Excel does not display the original value. Instead, it displays the number in the exponential ...

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

Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started. Spreadsheets usually hold a wealth of information, but it ...

When you use Microsoft Excel to analyze your company's data, you want to spot trends, successes and problems at a glance. Before you dive into an in-depth examination of specific sales results, ...

Fractions are enough to make you cry if you’re not a math whiz, but Microsoft Excel handles them very well. In fourth-grade math, you learned fraction basics: Fractions are a numerical representation ...

2 ways to display negative numbers in red in Microsoft Excel Your email has been sent To enter a negative value into a Microsoft Excel sheet, precede the value with a hyphen character, (-), which ...

Type an apostrophe before entering or pasting two numbers separated by a hyphen in Microsoft Excel to keep the numbers from being converted to their month and date equivalent. Dennis O'Reilly Former ...