| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom format to center
Is there anything I can add to the below custom format to make it centered
instead of right aligned? Thanks for any help. _(* #,##0_);_(* (#,##0);_(* "-"?_);_(@_) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom format to center
The number format doesn't set alignment.
You'll have to format that using the Format|Cells|alignment tab. (But with this format, your numeric entries won't be centered in the cell.) Andy wrote: Is there anything I can add to the below custom format to make it centered instead of right aligned? Thanks for any help. _(* #,##0_);_(* (#,##0);_(* "-"?_);_(@_) -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merge and Center and Center Accross Selection | New Users to Excel | |||
| Conditionl format for 3 cells Skipping the center cell | Excel Worksheet Functions | |||
| Format Cell as custom type but data doesn't display like I custom. | Excel Discussion (Misc queries) | |||
| shortcut to center text other than format toolbar? | Excel Discussion (Misc queries) | |||
| Center Across Selection Vertically Help. I am trying to center te. | Excel Discussion (Misc queries) | |||
Linear Mode
