Zero % change to "-" custom number format

D

David

We are working with an add-on product that exports data into Excel. The product exports raw data into our spreadsheet and we do the formatting. The problem we have is that we want to replace 0% with a dash "-". I have tried a few things in Cell Format with custom numbers, but without any luck. We are looking for a custom number format not a macro to resolve our issue

Thanks for your help in advance.
 
Top