Incell formatting and custom number formats

Originally Posted by 6StringJazzer

You don't say what data you are storing in the cell but from your description I assume that the underlining is applied to text, since it won't work for numbers. The text segment of your custom format overrides whatever other formatting is in the cell. Remove the text segment and your original text formatting will be restored:

Formula:

Please Login or Register  to view this content.

Got it.
But this means that there's basically no way for me to implement the same single space for underlined text (if e.g. right aligned) that my custom number format uses for numbers, right?

Originally Posted by 6StringJazzer

I see, I didn't know you wanted a space after right-aligned text.

I have never run across this before. I can't find anywhere that this specific conflict is documented, but my experimenting confirms that you can't have both text formatting and in-cell character formatting at the same time.

Just curious--why do you want do add a space at the end of everything?

Just like Excel does, I am used to numbers being right aligned and text left aligned (and dates are either/or).

For positive and negative numbers I use the above custom number format to have numbers/decimals properly aligned as I use opening and closing brackets for negative numbers, e.g. -200 is (200).
So 200 is properly aligned with number format: #,##0_)

The tricky part comes in when I use text as a heading which is the one case where it should not be left aligned but be aligned according to the data it repesents.
E.g. the heading is "Sales in €'000" where its corresponding data is numbers which are right aligned.
I then wish to right align also the heading to make it look proper in a table.
If I then try to make only the €'000 portion bold (for whatever neat or daft reason), I run into the above mentioned problem.

Long story short...maybe I am going a bit too heavy on formatting?!

A similar problem occurs when a heading is e.g. longer than a reasonable column width in which case I lose the 'trailing space' if I insert a manual line break with alt+enter; but in this case a possible workaround is at least to spread the heading over 2 separate lines (if the other table headings allow for this).

Well, all I can offer is that if these are headings, it's a one-time setup and you could manually insert the extra space at the end right into the cell.