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!
Bookmarks