Left Justification Question ?

[Robert11]

Hello:

Using Excel 97.
I know, Wow, but it does everything, for the most part, that I need.

Question:

I have a column of numbers; single and two digit.
On the menu, I have the icon that shoves it all to the left selected.

I have a few single digit numbers in the column, though, that I would like
to move over in the column by a space or two.

Not leading zeros, just want to move the single digit numbers over a space
to line up with the two digit numbers.

But, I still want the two digit ones left justified.

Won't let me do it.

How can I, please ?

Thanks,
Bob

 

[Ragdyer]

I'm on an XL97 machine today and there's nothing wrong with it as long as
it's sufficient for your needs.<g>

Anyway, after you align to the left, custom format using:
??

Yes, just 2 question marks!

 

[Harald Staff]

Just when you thought you'd seen it all. Thanks a ton RD.

Best wishes Harald