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

All the cells of negative numbers will become red, while the positive numbers will remain the same. You can create your own custom format in Excel to highlight negative numbers. Select the range of ...

The accounting format in Microsoft Excel 2010 is very similar to the currency format---both display the currency symbol next to every number. But the accounting format has a few differences that make ...

Number formats in Microsoft Excel define how data is displayed in your spreadsheet without changing the underlying values. As well as using number formats to present data as dates, times, percentages, ...

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

Your worksheets will be more polished and easy to read if you learn a few sophisticated formatting techniques. Most Excel users know how to apply basic numeric and text formats. But users who push ...

When you open an Excel spreadsheet, by default the columns are indexed by letters. However if you'd like to change the format and have the index in numbers, follow the step-by-step guide below. How to ...

If your job (or even your personal life) requires you to do anything substantial with numbers, chances are you use a spreadsheet app to do it. As a Mac user, you’ve got plenty of choices among ...