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.