Here I am using “Delta Symbol” to customized the Number formatting. You may insert any Special Character symbol with the same method. Just Copy the Special Symbol or learn shortcut of inserting any Symbol:
So Click at the beginning of “General” as shown below and insert “Delta Symbol” either:
In Currency Number Formatting or Accounting Number Formatting, there are two parts of format i) for Positive Number ii) Negative Number. So you need to insert it twice if you want to show Special Symbols for both formats else only at the beginning of Negative Or Positive Format. Lets go through below:
Did this article solve your query? Please comment at below box, if you find any challenge.
Have a great day ahead 🙂
Blank rows in Excel can be a real hassle, making it harder to move around and work with your data. But don’t worry—there are plenty of easy ways to get rid of these unwanted rows….
SUMIFS function is used to get the “total sum” of values for matching criteria across range. SUMIFS Function has required and optional arguments
Add new line in Excel cell lets you type on multiple lines within the same cell. Instead of having all the text in one long line, you can split it up to make it easier…
COLUMNS function is used to get the total count of columns in an array or in cells range for excel worksheet.
Introduction Calculate Percentage in Excel :-The term “per cent” comes from the Latin per centum, meaning “by the hundred.” A percentage is a way to show a part of something out of 100. You can…
Undo in excel very useful If you’re new to Excel or even if you’ve been using it for a while, you’ve probably made a mistake on a spreadsheet. Mistakes happen a lot, especially when working…