Forum Discussion
align decimals in a 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
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.
I already did all that. See the spreadsheet I posted above. As I said above, all cells were formatted as two-decimal numbers, but whether I aligned left or right, the alignment was inconsistent -- until I used "general".
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.
- 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!!!- 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
