ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   column alignment (https://www.excelbanter.com/excel-discussion-misc-queries/850-column-alignment.html)

ChSp

column alignment
 
How do I decimal align a column of numbers, them indent the numbers so they
line up with the column heading text, which is center justified?

Frank Kabel

Hi
AFAIK this kind of format is not supported by Excel

--
Regards
Frank Kabel
Frankfurt, Germany

"ChSp" schrieb im Newsbeitrag
...
How do I decimal align a column of numbers, them indent the numbers

so they
line up with the column heading text, which is center justified?



Dave Peterson

You could try to give them a format like:

#,###.?????

You'll have to play around with it to make it fit the cell nicely.



ChSp wrote:

How do I decimal align a column of numbers, them indent the numbers so they
line up with the column heading text, which is center justified?


--

Dave Peterson


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com