Need stair-step formatting in EXCEL

[dean12]

I've got a series of number in the square: A1:C3

Something like:

1 2 3
4 5 6
7 8 9

Now I want to format this so that each row's numbers are shifted to the left to give a stair-step appearance. Something like this:

1 2 3
4 5 6
7 8 9

Any ideas?

 

[Zathras]

You could use custom formats:

With normal right-aligned as the default, on row 2 (4,5,6)
use custom format

"#    "

(Pound sign plus four spaces), and on row 2 (7,8,9) use custom format

"#        "

(Pound sign plus eight spaces.)

 

[dean12]

Yes, that works - By golly I would have sworn that I tried that and found that the rightside blanks were stripped. Guess not. Thanks for correcting me!!!!!!!