View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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