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