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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top