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
Damien, for me, accounting formats have the $ sign on the left and the numbers are right-aligned. All numbers are right-aligned by default. Do you see numbers left-aligned?
- No no. As mentioned above, I meant to say RIGHT, but said LEFT instead. I knew what I meant, but unfortunately my fingers didn't get the memo when I typed it out!
LOL, I know that feeling. I always have to check three times before using the right word. When navigating in traffic I prefer pointing and saying "that way". I know people who get it right standing on their head and looking backwards. Not me.
The only situation where I don't have to think thrice is when playing music. Right hand and left hand are never getting confused.
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".
- Awesome to hear! As long as you are happy with the outcome, that is all that matters.
Best wishes Jonni.
Cheers
Damien
