Re: Left Justification Question ?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Robert11" <rgsros@xxxxxxxxx> wrote in message
news:1cidnZbtRIHtcGfZnZ2dnUVZ_qqdnZ2d@xxxxxxxxxxxxxx
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



.

Relevant Pages

  • Re: What is the Best Way to Fill a Pre Printed Form With Various Data
    ... The number of pages (single digit) ... The container number. ... | with a new batch of page and number of pages for each container. ...
    (microsoft.public.office.misc)
  • Re: truncating text
    ... Fakename wrote: ... only want a single digit number to display on the button. ... Problem is when I make the button real small, the text disappears and I get three dots instead. ... a large digit image is scaled to fill the space available: ...
    (comp.lang.java.help)
  • Re: Regexp match question !
    ... > I'm trying to match only a one single digit and wrote this code: ... Your regular expression has a word boundary anchor after a single ...
    (perl.beginners)
  • Re: Recent Coin Flip Post Reminds me of...
    ... various computational problems, e.g., extracting discrete logs. ... DA provides a Single Digit Number ... DB says Multiple And The Two Original 6 Digit Numbers are Multiplied ...
    (sci.crypt)
  • Re: find only 2 digits
    ... or do you want to left align the first digit ... Word MVP web site http://word.mvps.org ...
    (microsoft.public.word.docmanagement)