Professor Excel
custom, number, format, excel

Custom Number Formats: Big Guide, Popular Codes and a Free Download

Excel provides many default number formats. But often, these formats are not enough. For example:

Example: The default and a modifyed number format.

  • You want to display number in thousands or millions?
  • Or have a thousands separator for percentage values?
  • Or show a plus sign for positive values?

In such case, you need to create a custom number format. In this article, you learn everything you need to know. For making it easier for you, please feel free to download the example Excel file or the handy custom format card for printing it out.

[…]

thousands, decimal, separator, change, excel, powerpoint, thinkcell

Change Thousands & Decimal Separators in Excel, PowerPoint and ThinkCell

Sometimes you don’t want the comma “,” as a thousands separator, but rather a full stop “.”. Or you don’t want the full stop as the decimal separator. Changing these two separators in Office is easy: You can either do it system-wide or override the system settings.

[…]

excel, highlight, negative, color, red, minus

Easily Highlight Negative Values in Red Color in Excel

A good Excel table provides a quick overview of the most important facts and figures. One way of highlighting important numbers is by using colors. For example, values below zero should stand out.

force, cell, format, formatting, text, number

Force Any Cell to Your Desired Format in Excel

You are changing the cell format, for example from “text” to “number” and nothing happens? Or the other way around, you want to enter a phone number but Excel automatically converts it to a number? Unfortunately, Excel is very unpredictable when it comes to text/number formatting. Here is what you should do in order to force Excel to accept your desired format.
[…]

conditional, formatting, excel, background, color, icon, sets

Conditional Formatting in Excel: Background Color and Icon Sets

The “Conditional Formatting” button is hidden in the middle of the Home ribbon in Excel. Nonetheless, Conditional Formatting offers many options for visualizing your data. As the name already says, Excel can format your table depending on one or more conditions.

How to Use Conditional Formatting With Formulas in Excel

One advanced scenario of Conditional Formatting is to use formulas to determine the format. Let’s say, you want to change the background color of cell A if cell B has a certain value.