column contents alignment
 

I have columns in my worksheet with numbers in them. They have 2,3,4,5 or 6
digit numbers. I have elected to center the numbers in the column, and of
course show up at various widths based on the number of digits. What I want
to do is to align the numbers in the column/s, still centered, with the RIGHT
digit aligned through out the column. i.e.
2,345 and NOT 2,345
123 123
23 23
7 7
Thanks for any help and have a good day all..........Bill

column contents alignment
 

You might need to *cheat* and do a custom format of:
"#,# "
(minus the quotes)
and right-align your numbers. The extra spaces will cause it yo look like
your numbers are center-aligned, while the actual right-alignment will match
up the right side.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"bill" wrote:

I have columns in my worksheet with numbers in them. They have 2,3,4,5 or 6
digit numbers. I have elected to center the numbers in the column, and of
course show up at various widths based on the number of digits. What I want
to do is to align the numbers in the column/s, still centered, with the RIGHT
digit aligned through out the column. i.e.
2,345 and NOT 2,345
123 123
23 23
7 7
Thanks for any help and have a good day all..........Bill

column contents alignment
 

Custom format:

?????#

With "Center" still in force.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"bill" wrote in message
...
I have columns in my worksheet with numbers in them. They have 2,3,4,5 or 6
digit numbers. I have elected to center the numbers in the column, and of
course show up at various widths based on the number of digits. What I want
to do is to align the numbers in the column/s, still centered, with the
RIGHT
digit aligned through out the column. i.e.
2,345 and NOT 2,345
123 123
23 23
7 7
Thanks for any help and have a good day all..........Bill

column contents alignment
 

Your attempt to display things doesn't come out very well, even in a fixed
width font, but if you want to align the right digits, you need to use
right-aligned (which is default for numbers), not centred.
--
David Biddulph

"bill" wrote in message
...
I have columns in my worksheet with numbers in them. They have 2,3,4,5 or
6
digit numbers. I have elected to center the numbers in the column, and of
course show up at various widths based on the number of digits. What I
want
to do is to align the numbers in the column/s, still centered, with the
RIGHT
digit aligned through out the column. i.e.
2,345 and NOT 2,345
123 123
23 23
7 7
Thanks for any help and have a good day all..........Bill

column contents alignment
 

Thanks RagDyeR - Works Great, all I had to do was add the , in the right
place and it works..............Thanks, Bill

"RagDyeR" wrote:

Custom format:

?????#

With "Center" still in force.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"bill" wrote in message
...
I have columns in my worksheet with numbers in them. They have 2,3,4,5 or 6
digit numbers. I have elected to center the numbers in the column, and of
course show up at various widths based on the number of digits. What I want
to do is to align the numbers in the column/s, still centered, with the
RIGHT
digit aligned through out the column. i.e.
2,345 and NOT 2,345
123 123
23 23
7 7
Thanks for any help and have a good day all..........Bill

column contents alignment
 

You're welcome, and appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"bill" wrote in message
...
Thanks RagDyeR - Works Great, all I had to do was add the , in the right
place and it works..............Thanks, Bill

"RagDyeR" wrote:

Custom format:

?????#

With "Center" still in force.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"bill" wrote in message
...
I have columns in my worksheet with numbers in them. They have 2,3,4,5
or 6
digit numbers. I have elected to center the numbers in the column, and of
course show up at various widths based on the number of digits. What I
want
to do is to align the numbers in the column/s, still centered, with the
RIGHT
digit aligned through out the column. i.e.
2,345 and NOT 2,345
123 123
23 23
7 7
Thanks for any help and have a good day all..........Bill