Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Cell alignment, how do I update the default vertical alignment | Setting up and Configuration of Excel | |||
column alignment | Excel Worksheet Functions | |||
bar graph column label alignment | Charts and Charting in Excel | |||
Lines and borders are out of alignment with the cell contents | Excel Discussion (Misc queries) | |||
column alignment | Excel Discussion (Misc queries) |