Combining Customized Number-Format with the Accounting Format to get a dash "-" when zero?
Dear Forum,
I am not sure whether this is possible to be done Manually and therefore I put this query in the Programming in case of any VBA intervention..
I often use a particular format for displaying Indian Currency with a "Rs" prefix with the number values, which is quite popular at my work-place.
However, recently I also came across an Accounting Format for plain numbers which displays a simple Dash "-" when the values of the cell is zero..
I would like to have this "-" in my existing Format when the cells contain a zero..
The Great thing about the Accounting Format is that it displays the "-" in the center which looks cool, but it also makes a Normal Number in the center too.
In my Number-Format I always keep the Number with decimals and without decimals Horizontal Right Aligned..
So is there a possibility to combine the best of Both and Get a New Format which displays the "-" when no values and also numbers as in the existing format..
Please find the formula for the Rupees Number Format:
Please Login or Register to view this content.
Also one small request I want to increase the Range from 9999999 to more, so how can that be done I am using this from the NET..Please Login or Register to view this content.
Warm Regards
e4excel
Bookmarks