Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom Formatting
From viewing the default accounting and currency cell formats, respectively, I note that the former/latter cannot/can be centered across a (single) column and that negative values do/don't appear with parentheses around them. Since my client wants centered values with parentheses (if negative), I need a hybrid of these two.
The formatting currently installed seems to be like an accounting format, so I can't center it. I'm not sure what it adds that the normal default accounting format doesn't have, but it seems OK except that I can't center it across a column. It is: _(* #,##0_);_(* (#,##0);_(* "-"??_);_(@_) In any event, can I edit this format, or modify a copy of it so as to be able to center it across a column? Thanks! Dean |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Formatting | Excel Worksheet Functions | |||
Custom formatting | Excel Discussion (Misc queries) | |||
custom formatting | Excel Discussion (Misc queries) | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
custom formatting | Setting up and Configuration of Excel |