Using rounded numbers for display, but not for the calculation.
 

Hello,

I am dealing with a workbook that calculates numbers in millions. I
would like to display calculated amounts rounded to the nearest
thousand. However, I would like to perform my calculations on the
numbers rounded to a nearest dollar. What would be the solution for
this? Is there a special formatting feature?

Thanks!!!


--
MKode
------------------------------------------------------------------------
MKode's Profile: http://www.excelforum.com/member.php...o&userid=32061
View this thread: http://www.excelforum.com/showthread...hreadid=518497

Using rounded numbers for display, but not for the calculation.
 

In the cells round the value top the dollar

=ROUND(amt,0)

but format the cells as #,##0,

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"MKode" wrote in
message ...

Hello,

I am dealing with a workbook that calculates numbers in millions. I
would like to display calculated amounts rounded to the nearest
thousand. However, I would like to perform my calculations on the
numbers rounded to a nearest dollar. What would be the solution for
this? Is there a special formatting feature?

Thanks!!!


--
MKode
------------------------------------------------------------------------
MKode's Profile:
http://www.excelforum.com/member.php...o&userid=32061
View this thread: http://www.excelforum.com/showthread...hreadid=518497