cell value should = blank

[dgavilanes]

Hi all,


I have this code that works fine except I'm noticing now that where there no data is present the output should be blank, but I'm getting a '0%' value instead. I'm attaching a sample dataset for you to review it

Regards,, Dennis


http://sdrv.ms/PsMq0W

 

[SirJB7]

Hi, dgavilanes!

Try setting number format as 'General;General;"-"' (un-single-quoted) for range B17:D24.

Regards!

 

[dgavilanes]

Thanks!!!!

 

[SirJB7]

Hi, dgavilanes!

Glad you solved it. And welcome back whenever needed or wanted.

Regards!