zero against dash with indian style rupee format in custom format in excel

[sivaprakasam]

Hi,

I am using the Excel 2013,

i need the convert to indian style rupee format in custom format including negative value, and in case, if any value is "0", return value should be "-" (dash)

excel file enclosed

anybody help me...

 

[Faseeh]

Hi,

Please see this post of chandoo:

https://chandoo.org/wp/indian-currency-format-excel/

 

[sivaprakasam]

Tnq