| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Customer Currency Formatting
Does anyone know how to format the following examples as shown?
$6,545,000 to $6.5M $6,545 to $6.5K -- Rob |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Customer Currency Formatting
Maybe...
[999999]$#.0,,"M";$#.0,"K" Rob wrote: Does anyone know how to format the following examples as shown? $6,545,000 to $6.5M $6,545 to $6.5K -- Rob -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Customer Currency Formatting
That worked! Thank you.
-- Rob "Dave Peterson" wrote: Maybe... [999999]$#.0,,"M";$#.0,"K" Rob wrote: Does anyone know how to format the following examples as shown? $6,545,000 to $6.5M $6,545 to $6.5K -- Rob -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CONVER CSV CUSTOMER DATA TO A CUSTOM INDIVI CUSTOMER PRICE SHEET | Excel Discussion (Misc queries) | |||
| conditional formatting for currency | Excel Worksheet Functions | |||
| Currency Formatting | Excel Discussion (Misc queries) | |||
| Currency Formatting. | Excel Discussion (Misc queries) | |||
| Currency Formatting | Excel Discussion (Misc queries) | |||
Linear Mode
