Forum Discussion
Solved
align decimals in a column
I'm using Excel 2007, but I was astounded to find there is no way to align numbers by decimal point. The only option I have is left align or right align. I was careful to format all the number column...
Greetings, Damien!
I'm still not sure I believe this, but I tried using "General" alignment, with no indent, and all the decimals aligned perfectly. Go figure. You would think, though, that a leading spreadsheet program like Excel would have the option to align decimals!
Thanks for your input.
Jonni
Jonni Anderson As I said above, you use different "indent" settings and that will change the distance of the number from the edge of the cell. You need all "indent" settings to be the same.
Ingeborg: I did global formatting on the cells with numbers and set all indents to "0". (Or thought I did.) I'm not arguing with your findings; I'm just wondering why the formatting I did didn't "take" in all cells.
Thanks for your input.
- Sometimes weird stuff happens and I find it's better to just use format painter to replicate the working cells format, or to start fresh.
Sometimes it takes more time trying to figure out the quirk of the problem than it is to solve it!
Best wishes for your Excel stuff!
Cheers
Damien
