Is there any way of formatting a currency value on a revenue report where the
figures are to appear in £'000's?

For example, a value of 123,456.78 needs to appear in the format: 123.45678
(but rounded to zero decimal points, so is shown as 123)

Again, a value of 98,765.43 needs to appear as 99 (98.76543 rounded to zero
decimal points)

Is this possible?