Custom format to center

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

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