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 🙂
How to Export Access Data to Excel using VBA Code? Creating a VBA tool in MS Access is always better as compare to MS Excel. MS Access provides better user interface and ability to handle…
Merge Excel Files From last few months, we have been receiving frequent requests from users for a VBA tool which can consolidate Excel files from a folder. So here we come with one more free…
In MS Access, the best way to create a multiuser tool is to divide your solution. One part acts as interface and other one acts as database. You can have multiple copies of the interface distributed to users which are connected to central MS Access database saved at common shared drive. To connect the interface to database, you can use link table feature (Access>External Data>Import & Link) available in MS Access. Below is a commonly required VBA code which helps the developers to re-link MS Access linked tables when the database is renamed or moved to other location
How to use VBA to open Workbook in Excel? There are few VBA codes which are commonly used by every developer. One of them is giving an option to user to browse a file. Below is a…
Video: How to Hide Worksheet in Excel? Hide Sheet in Excel When I was creating an excel dashboard, there were multiple sheets which I used for calculation purpose and never wanted anybody to make any…
VBA code that will sum cells by its color through excel function. This code will really help in making the analysis and presentation better.