Display 1.6 as 1 (0 D.P.) instead of 2?

[PBcorn]

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

 

[Bill Sharpe]

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

Use 1.01, 1.02, 1.03 instead of 1.1, 1.2, 1.3.

Bill

 

[Elkar]

Will your numbers be larger than 31? If not, you could format the cells as a
date, showing only single digit day. So, use the cell format: d

HTH
Elkar

 

[Roger Govier]

Hi
Without using an extra column, you can't.
Even with VBA, if you run code to change the appearance of the cells,
the underlying values themselves would alter.