Category Archives: Custom Formatting

No Thumbnail

Excel Custom Formatting Adding Characters and Text

When working with custom formats in Excel there may be times you want to add a specific character or text string before or after the cell value. I will be explain this using examples in this article. – Literal Characters: There are certain characters that will

No Thumbnail

Excel, Custom Formatting Semicolon Character

The semicolon character is a special character used in custom formatting. It basically acts as an IF statement, it checks for the following conditions: Positive numbers Negative numbers Zeros Text Values You can have upto 3 semicolons in a custom formatting. Note: The rules mentioned in this article

No Thumbnail

Excel Custom Formatting, Removing Digits

When working with custom formatting in Excel one of the things you might want to do is remove several digits from being displayed. This can be done using the comma character. I will explain this using Examples. Please note that this comma character is different

No Thumbnail

Excel Custom Formatting Conditions

Using custom formatting you can test for different conditions. You can use different formatting when different conditions are met. For example if the value in a cell is greater than 5 you can apply a custom formatting to color the font red, and if its less than

No Thumbnail

Excel, Custom Date Formatting

Custom formatting, what is it? When working with Excel there may be times that you want to display a date. For example lets say you want to display the date January, 3rd 1988. In the figure below all the cells are showing the same date: The

No Thumbnail

Excel, Custom Formatting Colors

Using custom formatting you can change the cell font color. For example you could use a custom formatting that colors negative numbers red, or numbers larger than a certain amount blue. There are 8 different colors where you can choose from: [Black] [Green] [White] [Blue]

No Thumbnail

Excel Custom Formatting, 0, # and ? characters

In this article I will explain the characters “0”, “#” and “?” used in custom formats. – “0” Character: The “0” is a placeholder for digits. On the left hand side of the decimal: If  there aren’t enough digits to fill the placeholders, zeros will be added

No Thumbnail

Excel, Custom Formatting, Month Language

If you’ve worked with dates in Excel there may be times you want to display dates in a language other than english. For example lets say you want to display the following date in german: German equivalent: As previously explained in the article below you have 2 different

No Thumbnail

Excel, Custom Formats

In this article I will briefly explain the different concepts of custom formatting, and provide links to more detailed explanation of each. You can download the file related to this article from the link below Custom Formats.xlsx – Custom Date Formatting: There are endless ways  to display a

No Thumbnail

Excel Custom Formatting, @ Character

If you’ve been reading about custom formatting in Excel you’ve probably stepped on the @ character. So what is it? For input values of the text type the @ character specifies where to put the the text. I will explain this using examples – Example