Moving decimal place to show currency in £000's
 

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?

Moving decimal place to show currency in £000's
 

Format Cells... Number Currency Decimal places 0

This will round 1.1 to 1
This will round 1.8 to 2
--
Gary''s Student - gsnu200809


"Sarah (OGI)" wrote:

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?