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

PBcorn wrote:
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

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


"PBcorn" wrote:

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

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.


--
Roger Govier
------------------------------------------------------------------------
Roger Govier's Profile: http://www.thecodecage.com/forumz/member.php?userid=81
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=82544