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
Can you post a screenshot of this? General does not align by decimal point. Excel does not have such a functionality. You need to format all cells with the same number of decimals and align them to the right, then the decimal points will be aligned correctly.
Hahaha oops. I meant to say RIGHT align in my post and ended up saying left instead (the file uploaded is right aligned as intended).
Clearly I need to learn my left from my right!!!
Clearly I need to learn my left from my right!!!
- I never learned that, either. Driving directions are a nightmare for me!
Haha oh gosh I am not going to live this one down anytime soon I think :p