Rounding numbers
If the actual value were 55.449998756 what would you want to see?
$55.45? (which is what I think you're getting)
or
$55.44 (in which case you can use =INT(A1/100)*100 (if A1 is the cell in
question)
"ac/blue01" wrote:
Hi,
I am using Excel 2003 and I have a workbook that has many functions. I can't
seem to get the cells with the currency setting with two decimals without it
rounding the numbers. Is it possible to change this format, to display only
decimal places, without rounding and using the functions.
|