View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Umlas, Excel MVP Bob Umlas, Excel MVP is offline
external usenet poster
 
Posts: 320
Default 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.