How can I center a number in "comma" format?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Eric,

You could try

Format|cell|alignment

set horizontal and vertical alignment to centre

Mike
 
hi,
you can't do it if you are using accounting format.
but you should be able to if you use currency format or number and check the
1000 seperator(comma).

regards
FSt1
 
Thanks. I've always considered the comma icon and the increase/decrease
indent the normal way to add a comma to my numbers. The trouble has been
that it prevents the normal centering from working.

Thanks for the workaround. (Or should I consider it a "feature"?)
 
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.
 
No, that's not the problem I see.

When I talk about comma format, I'm talking about what I get when I click on
the comma on the formatting toolbar. I believe that results in Accounting
format.

FSt1 has made a good suggestion. If I use Number format and click the "Use
1000 separator (,)", that has the same result as to the comma, but does not
disallow centering. It's not quite as easy as just clicking the comma on the
toolbar, but it gets the result I want.

Thanks for your suggestion.
 
Hi Eric

But the decimal points don't align.
I had thought that was what you were complaining about.
 
No, I was looking simply for centering. If the numbers are the roughly the
same size, it doesn't necessarily matter if all the decimal points and/or
commas don't line up (depending on one's taste, of course). In this case, I
had no decimal points, just comma separators, and all the numbers were the
same width. I simply wanted them with commas, and centered.
 
Back
Top