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
Some of your cells have an indent of 0 e.g. F8, others have an indent of 1 e.g.F4 to F6.
A different indent will impact the alignment of the decimal point, even if all numbers have 2 decimals and are right-aligned.