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!!!

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>