I have some cells which use a decimal place to act as a postfix. Eg. I want
1.1, 2.1, 3.1 , then further down 1.2,2.2,3.2... .I want the Integer part to
be displayed and hide the postfix part,using cell format, but when the
postfix reaches 0.6 excel rounds up and displays the number as 2 (0 DP) when
it should be displayed as 1.
I dont want to use formulae/hidden column etc.

any suggestions?

Thanks