Description FormatNumber is a property of the Range object of Excel. The Range object can be considered as a cell or a group of cells — be that a single cell, a column in an Excel table, or the UsedRange of an Excel sheet. The
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
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
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
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
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
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]
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
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
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