software

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: www.excelforum.com/member.php...oamp;userid=32061
View this thread: www.excelforum.com/showthread...hreadid=518497In 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)

quot;MKodequot; gt; wrote in
message ...
gt;
gt; Hello,
gt;
gt; I am dealing with a workbook that calculates numbers in millions. I
gt; would like to display calculated amounts rounded to the nearest
gt; thousand. However, I would like to perform my calculations on the
gt; numbers rounded to a nearest dollar. What would be the solution for
gt; this? Is there a special formatting feature?
gt;
gt; Thanks!!!
gt;
gt;
gt; --
gt; MKode
gt; ------------------------------------------------------------------------
gt; MKode's Profile:
www.excelforum.com/member.php...oamp;userid=32061
gt; View this thread: www.excelforum.com/showthread...hreadid=518497
gt;