Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding numbers up or down | Excel Discussion (Misc queries) | |||
Rounding Numbers. | Excel Worksheet Functions | |||
rounding numbers | Excel Worksheet Functions | |||
Rounding Numbers | Excel Discussion (Misc queries) | |||
Rounding Numbers | Excel Discussion (Misc queries) |