How do I get a right justified column of numbers

I have a column of numbers ranging from about 1 to about 999 (1 to 3 digits). I want these values to appear in a column in a report, right-justified.

<Disclaimer> Yes - I know Excel is not a report writer, and Yes - I know that if I want to think in COBOL I should go back to the dim and distant past </Disclaimer>

BUT

How do I get a column of numbers in a report (a series of strings) to show up right justified?

I've tried all sorts of format codes, and none of them work (they all shift the value to the left). I've worked around this in the past by prepending a string (comprised of spaces) of the maximum length adding the numerical value and then taking the rightmost characters:

a=1

result1=right(string(6," ") & a,6)

a=999

result2=right(string(6," ") & a,6)

t hi s seem slik a pre tty st o o o PID wa yt od ot hi ng s!


Can Excel VBA produce this rather basic request without requiring these contortions?

Tony (Head Against Wall Mode Again)