B
BorisS
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.
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.