Moving decimal place to show currency in £000's

[Sarah (OGI)]

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?

 

[Gary''s Student]

Format > Cells... > Number > Currency > Decimal places > 0

This will round 1.1 to 1
This will round 1.8 to 2