| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
help with formats please
Hello,
I have numbers in currency format, eg £8900.00 which I want to display as £8.5K . Can someone help me with the format for this please ? Thanks KK |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
help with formats please
£##.0,K
Note: this will give £8.9K not 8.5 Use Alt + 0163(numpad) to enter the £ sign Gord On Fri, 2 Mar 2012 12:41:47 -0000, "dido22" wrote: Hello, I have numbers in currency format, eg £8900.00 which I want to display as £8.5K . Can someone help me with the format for this please ? Thanks KK |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
help with formats please............. Thanks
Thanks for the help. The £8.5K was my mistake, I meant 8.9.
K "Gord Dibben" wrote in message ... £##.0,K Note: this will give £8.9K not 8.5 Use Alt + 0163(numpad) to enter the £ sign Gord On Fri, 2 Mar 2012 12:41:47 -0000, "dido22" wrote: Hello, I have numbers in currency format, eg £8900.00 which I want to display as £8.5K . Can someone help me with the format for this please ? Thanks KK |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formats, how to scroll and view all formats? | Excel Worksheet Functions | |||
| Copying formats - column widths, formats, outlining to worksheets | Excel Worksheet Functions | |||
| Conditional formats- paste special formats? | Excel Discussion (Misc queries) | |||
| paste conditional formats as formats | Excel Discussion (Misc queries) | |||
| Formats: Too many different cell formats error message | Excel Programming | |||
Linear Mode
