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

M

MKode

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

Bob Phillips

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)
 
Top