ExcelBanter - Custom format to center

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Custom format to center (https://www.excelbanter.com/excel-discussion-misc-queries/245439-custom-format-center.html)

Andy

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);_(* "-"?_);_(@_)

Dave Peterson

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

All times are GMT +1. The time now is 09:58 AM.