Hide zero values but keep number format

Now i'm using 0;;;@ in Format Cells to hide zero values. When there is an entry in the cell the number appears, but not in number format (with decimals). Is there a way to hide zero values but keep the number format?

hesa could you provide a bit more detail as to what you're data looks like and what you're trying to achive.

You're stating you don't want to view zero values but you want to see decimals.

Are you suggesting that

4.0 should be displayed as 4
But
4.1 should be displayed as 4.1?

OR

Are you asking that in your cells you have blank value if it's a zero value, but if it's not then you want to format as number with decimal places?

The second case. Zero values should be displayed as blank cells and other numbers should be in decimal format.

You don't need custom formatting for that. This is just an option for the worksheet. Go to Excel options > advanced. There you can find "Display options for this worksheet". Uncheck "show a zero in cells that have zero value". You can do this for every sheet in your workbook.

As above, both cases work, just depends if in other circumstances (or other columns) you do want to see the zero values