Change decimal places for zero values

[YasserKhalil]

Hello everyone
I have this line that works well

Code: Select all

Columns("B").NumberFormat = "0.00%" (2 decimals)

This places two decimal places but I need to exclude the zero values to be 0 decimal places

[SpeakEasy]

Columns("B").NumberFormat ="0.00%;-0.00%;0"

[YasserKhalil]

Thank you very much.