| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count first decimal place only | Excel Discussion (Misc queries) | |||
| Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
| Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
| How do I place currency symbols by themselves in Excel? | New Users to Excel | |||
| Fixed decimal place | Setting up and Configuration of Excel | |||
Hybrid Mode
