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
Hi Jonni
As far as my experience goes, I don't think you've missed anything and I suggest it's best to use the (left) align option as you have touched on.
I've done that to your workbook as attached.
Because you are using 2 decimal places, it makes sense to go left.
Using the Accounting format will also give you a left alignment and $ sign on the right.
Maybe someone else may have a better answer, but I think given you have a very simple table of data, the quickest and easiest fix is left align.
Hope that helps.
Cheers
Damien
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.
- 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!
- Awesome to hear! As long as you are happy with the outcome, that is all that matters.
Best wishes Jonni.
Cheers
Damien
