Moving decimal place to show currency in £000's

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?
 
G

Gary''s Student

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

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