Please modify my code for custom formatting for decimal places with certain numbers

Hi

I'd like to format some cells so that and number below 1 has 1 decimal place(0.1) , any number above 1 has no decimal place (5) and if the number is zero then don't display anything (). Additionally it would be nice if any text would just be left to display as text (text).

So far I have come up with the following code

[<1]_(###0.0_);_(###_)

It almost does the job however if a zero is present 0.0 is displayed. To be a little more specific the cells displaying 0.0 are actually blank, they use an indirect function to retrieve numbers from elsewhere and when no number is present currently 0.0 is displayed. The indirect function happens to be =INDIRECT("item"&D1&C1&"_week_"&$B1&$B2). I wish that when this code did not return a value that the cells could be empty rather than containing 0.0.

Can my code be easily modified to include a further clause involving zeros?

Btw I had almost come up with something that did this but it left a decimal (.) after some whole numbers and I didn't like this.

Thanks in advance for any assistance

Michael from Australia.

That turns the 0.0 into just a 0

It's a definite improvement but is there some way to have nothing show at all?

i.e incorporate "" to display a blank cell in place of the zero