Rounding numbers
 

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.

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.

Rounding numbers
 

Excel will always round up the display but the underlying values are still
as original.

12.126789 formatted as currency 2DP will display as 12.13 but the value is
still 12.126789

This can lead to what looks like errors in arithmetic.

See John McGimpsey's site for "penny off" explanation and workarounds to
ensure accuracy.

http://www.mcgimpsey.com/excel/pennyoff.html


Gord Dibben MS Excel MVP


On Tue, 26 Aug 2008 12:52:11 -0700, 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.

Rounding numbers
 

Don't you mean INT(A1*100)/100??
--
Wag more, bark less


"Bob Umlas, Excel MVP" wrote:

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.