Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Aug 2001
    Location
    Arizona, USA
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel (Excel 2000 SR1)

    I have a 2-column document, both columns are formatted as text.

    Column 1 has many numbers that lead off with 1, 2 or 3 zeros. When trying to sort this column, all numbers leading off with a zero appear, as a group, in the middle of the other numbers. The ones beginning with a zero do not sort numerically and none of the other numbers sort numerically.

    Can someone help me with this? I have over 3,000 numbers I am trying to sort.

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel (Excel 2000 SR1)

    It sounds like some of the cells contain text and some contain numeric values. However, it is really difficult to tell without being able to see the sheet. Can you post a copy so we can look at it?
    Legare Coleman

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Excel (Excel 2000 SR1)

    As Legare has suggested post the WB, see also <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=xl&Number=71410>this thread</A> for a brute force macro to set numbers in text format as values.
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Silicon Valley, California, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel (Excel 2000 SR1)

    To see quickly which ones are formatted as numbers versus text, simply select the column, then choose Edit (menu), Clear..., Formats. By default, numbers are right-justified and text is left-justified. This could help you troubleshoot...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •