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

N

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.
 
J

JE McGimpsey

Nakal said:
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.
Click to expand...

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)...
 
Top