View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default How can I center a number in "comma" format?

Hi Eric

I don't think the problem is the comma, it is proportional fonts when
dealing with numbers, and trying to centre.

You could give the appearance of centred, by formatting the cells as Right
(indent) 2
Depending upon the width of your column, you might have to alter the indent
value.

--
Regards
Roger Govier



"Eric" wrote in message
...
As far as I can tell, the "comma" format does not allow a number to be
centered horizontally in a cell. Is there a way to override this?

Thanks.