Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default How can I center a number in "comma" format?

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.
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: How can I center a number in "comma" format?

Yes, you can center a number in "comma" format horizontally in a cell. Here's how:
  1. Select the cell or range of cells that you want to center.
  2. Click on the "Home" tab in the ribbon.
  3. Click on the "Alignment" group.
  4. Click on the "Align Center" button.

This will center the contents of the selected cells horizontally.

If the number is not centered after following the above steps, it may be because the cell is not wide enough to accommodate the number. In this case, you can adjust the column width by hovering your mouse over the column boundary until the cursor changes to a double-headed arrow, then click and drag the column boundary to the desired width.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default How can I center a number in "comma" format?

Eric,

You could try

Format|cell|alignment

set horizontal and vertical alignment to centre

Mike

"Eric" wrote:

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.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default How can I center a number in "comma" format?

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

"Eric" wrote:

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.

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default How can I center a number in "comma" format?

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"?)

"FSt1" wrote:

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

"Eric" wrote:

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.



  #6   Report Post  
Posted to microsoft.public.excel.misc
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.



  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default How can I center a number in "comma" format?

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.


"Roger Govier" wrote:

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.




  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,480
Default How can I center a number in "comma" format?

Hi Eric

But the decimal points don't align.
I had thought that was what you were complaining about.

--
Regards
Roger Govier



"Eric" wrote in message
...
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.


"Roger Govier" wrote:

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.






  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default How can I center a number in "comma" format?

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.

"Roger Govier" wrote:

Hi Eric

But the decimal points don't align.
I had thought that was what you were complaining about.

--
Regards
Roger Govier



"Eric" wrote in message
...
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.


"Roger Govier" wrote:

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.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
no comma separator for ="total"&"$ "&sum(a1:a10) Jeff Excel Worksheet Functions 3 August 9th 06 05:06 PM
"Merge and center" grayed out in excel form Viktor Excel Discussion (Misc queries) 1 June 6th 06 10:35 PM
Formulae or format to change a number "1" into the word "one Excel Help Excel Discussion (Misc queries) 1 May 30th 06 04:25 PM
Format a column wihtout using "Format-Cells-Number-category-etc" serve Excel Worksheet Functions 4 February 24th 06 01:54 AM
"Center Across Selection" icon in excel 2003 no merge dan Excel Discussion (Misc queries) 1 November 30th 05 06:14 PM


All times are GMT +1. The time now is 11:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"