In this article we will learn about how to add special symbols to the number format in Microsoft Excel 2010. We can create so many symbols in excel like check, degree, rupee, tick & many more.
To add special symbols to the number format, such as symbols that are not included in the currency or accounting formats in Microsoft Excel 2010 and 2013.
There are two different ways to add the special symbol to the number format.
1st CHAR formula
2nd Custom Format
CHAR: - This formula displays the symbol. To add a symbol to the new format you create, copy the symbol to the Type box.
Syntax of “CHAR” function: =CHAR(number)
Example:Range A1:A10 contains the number 33 to 42. To return the special character, follow below given steps:-
Custom Format: - We can use Custom Number Format, to display a Number in Million or Display it in some Color. It’s a tool for old versions of excel when there was no Conditional Formatting option in Excel. All conditional options are performed by using Custom Number Formal.
Add special symbols to the number format by using CHAR formula.
For Example: We have product data with the amount. We want to format the amount in the Euro symbol.
To add the symbol with amount follow below given steps:-
Add special symbols to the number format by using the Custom Format
To add the symbol with the amount through Custom Format follow below given steps:-
This is the way to update the special symbols with numbers in Microsoft Excel.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.