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