Format Cells/Alignment/Left Indent - So what ? Everybody wantsRight Indent, no ?

[SVEN AERTS]

If you have a column :

1,20
10,30
4,5
23.22

How do you want them:
1,20
10,30
4,5
23.22

Right ?
Well, that's Text Alignment Right Indent=1

But boehoe, we only get the option

1,20
10,30
4,5
23.22

= Left Indent=1

Or am I missing something ?

 

[JE McGimpsey]

If you have a column :

1,20
10,30
4,5
23.22

How do you want them:
1,20
10,30
4,5
23.22

Right ?
Well, that's Text Alignment Right Indent=1

But boehoe, we only get the option

1,20
10,30
4,5
23.22

= Left Indent=1

Or am I missing something ?

I assume you're using the comma as a decimal separator (your last
example is confusing - XL won't recognize both "." and "," as decimal
separators at the same time). You can align decimals using ? in the
number format:

Format/Cells/Number/Custom 0,??

will align all the decimals.

Note that this will leave off insignificant zeros, so your data would
look like:

1,2
10,3
4,5
23,22

You can see more about formatting numbers in Help: "About custom number
formats"