Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom formatting
Okay, tried this before, but didn't get the full answer I needed. The
following custom formula: [100000000]#\,###\,##\,##\,###;[100000]#\,##\,###;#,### works to provide me with the following desired results: 0-100,000 produces "##,###" (basically standard US formatting) 100,000-100,000,000 produces (for 1,000,000) "10,00,000", (for 10,000,000) "1,00,00,000", and (for 10,000,000,000) "1,000,00,00,000", all of which is exactly what's needed. Here's what I cannot figure out how to do (using '07 Xl) 1) after the "1,000,00,00,000" that is displayed for my highest value, each 3 digits should be grouped (like regular spacing of US digits). Cannot get this to happen 2) Need negatives RED and in parentheses Any help is appreciated. -- Boris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Formatting | Excel Discussion (Misc queries) | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
Custom Formatting | Excel Discussion (Misc queries) | |||
custom formatting | Excel Discussion (Misc queries) | |||
custom formatting?? | Excel Worksheet Functions |