Excel Blank the Cell command on Zero But decimals remove 1

[mstrcmtr]

By the help of following command in Excel Blank the Cell if Zero

e.g. i = 30

oXs.Range('Z5:'+ 'Z'+ALLTRIM(STR(i))).NumberFormat = '0;-0;;@'

But it will also remove the decimals

What is the way to protect decimals and as well as blank if cell has zero value

 

[GriffMG]

Is it as simple as changing the format string to include fixed decimals?
'0.00;-0.00;;@'

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you. ​

 

[GriffMG]

Pleased you are happy

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you. ​