How about dividing it by 1000 as
=ROUND('[Monthy Report Prior FY - ANG.xls]Sheet1'!$J$21,-3) /1000


"R Champ" wrote in message
...
I need to have the result read in thousands but use the number from
millions.

Example, my formula result is 521,689,745.04 I need the cell to read
521,690. I need to take away more then just the two decimal places. I
need
to take away the two decimal places plus the next three places and round
up.

The column will start with "IN MILLONS"

The following does not accomplish what I want; =ROUND('[Monthy Report
Prior
FY - ANG.xls]Sheet1'!$J$21,-3)

This will result in 521,690,000 and again I need 521,690.

Thank you in advance,
R Champ