Hi,

Hopefully this is an easy one. I have a cell with a custom number format 0.##.

So if the result in this cell has one or two decimal places it will show those decimal places (e.g. 4.5, 4.55).
However when the value is a whole number the decimal point is shown (e.g. '4.' instead of '4').

This is the first time I've had the need to use a custom number format so not sure if it is something silly I've missed or not. Also this has only been checked in 2013 Excel so far and would need to be backward compatible to 2007.

Any other workarounds would be greatly appreciated too.

Thanks
Harribone