On Nov 2, 4:51*pm, FSt1 wrote:
your "text" custom format failed because you cannot
appliy custom number formats to text. you can change
the font, size, style but that's it. as to lineing
up, you will just have to eye ball it and hope no one
notices.

Thanks. Speaking of eye-balling, upon closer inspection, I see that
my work-around did not really work. It seemed to line up on the
display, but not on the printed output. Looks like the indented text
is half a character(!) to the right. "Good enough for government
work".

(Although we would miss Mars big time! ;-)

PS: Seriously, as far as eye-balling the text alignment goes, I have
had no success entering spaces on the right of the right-aligned text
with zero indentation. I suspect that Excel always trims text on the
right, which makes some sense, IMHO.