+ Reply to Thread
Results 1 to 7 of 7

Rearrange numbers

  1. #1
    Forum Contributor
    Join Date
    01-21-2010
    Location
    Chicago,Illinois
    MS-Off Ver
    Excel 2019
    Posts
    206

    Rearrange numbers

    I have 1 column with three numbers in it. I want to arrange the numbers from Low to High
    Last edited by Jordans121; 03-02-2010 at 01:14 AM.

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,887

    Re: Rearrange numbers

    Hi Jordans, have you tried using the Sort button or via the menu? Select your column and then click the small "A->Z" button in the toolbar. Or I think there's a Sort menu underneath the Data menu (don't have 2003 any longer, so I forget exactly where).

  3. #3
    Forum Contributor
    Join Date
    01-21-2010
    Location
    Chicago,Illinois
    MS-Off Ver
    Excel 2019
    Posts
    206

    Re: Rearrange numbers

    Tried the sort button but it changes all of my numbers in the column to 14

  4. #4
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,887

    Re: Rearrange numbers

    Sorting doesn't change data. Do you have three numbers in a column, or three formulas in a column that result in numbers?

  5. #5
    Forum Contributor
    Join Date
    01-21-2010
    Location
    Chicago,Illinois
    MS-Off Ver
    Excel 2019
    Posts
    206

    Re: Rearrange numbers

    Sorry, I have 1 number in Column A,B,C

  6. #6
    Forum Contributor
    Join Date
    01-21-2010
    Location
    Chicago,Illinois
    MS-Off Ver
    Excel 2019
    Posts
    206

    Re: Rearrange numbers

    Maybe there is a formula that can do this

  7. #7
    Forum Contributor
    Join Date
    01-21-2010
    Location
    Chicago,Illinois
    MS-Off Ver
    Excel 2019
    Posts
    206

    Re: Rearrange numbers

    The sort button sees to only works for rows and not columns

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1