How can Excel 2003 display 13.68 as 13.6 and not change the value?

[Nakal]

I am looking for a cell format which allows a 2 decimal place number to be
displayed as a single decimal number without the excel roundup

eg display 13.68 as 13.6 , not as 13.7 and also NOT change the underlying
value.

ie I am looking for a number format not a math function eg TRUNC or
ROUNDDOWN which change the underlying value.

 

[JE McGimpsey]

I am looking for a cell format which allows a 2 decimal place number to be
displayed as a single decimal number without the excel roundup

eg display 13.68 as 13.6 , not as 13.7 and also NOT change the underlying
value.

ie I am looking for a number format not a math function eg TRUNC or
ROUNDDOWN which change the underlying value.

You can't do that with cell formatting.

One alternative would be to put the calculation, say, in a hidden column
or row, with a displayed row that referenced the calculation cell using
FLOOR() or ROUNDDOWN().

BTW - you wandered into a Mac XL newsgroup (hence the .mac. in the
newsgroup name)...