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

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

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

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

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

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

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

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