Number Formatting - disply values >1 as integer, values <1 as decimal and no zeros

Hi everyone,

I need to create a number formatting that shows values greater then 1 as integer and positive values less then 1 as decimal. (I don't have negative values).
The problem is I have zero values which I don't want to display (in the sheet a formula summarises various values from other sheets. For most cells the formula result is zero.) At the moment I am using this number formatting: 0;-0;;@ but it only shows integers.
Is there a way to modify it as described?

Thank you!

Mr. Shorty, thanks for the tip! Looks like it will do the job, I'll have to read it carefully and play around with the format.