Forum Discussion
align decimals in a column
- Mar 21, 2018
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