Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.sys.mac.apps > #17855

Re: Any way to get Excel to sort these numbers properly?

Path csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!news.albasani.net!.POSTED!not-for-mail
From PhillipJones <pjonescet@comcast.net>
Newsgroups comp.sys.mac.apps
Subject Re: Any way to get Excel to sort these numbers properly?
Date Mon, 30 Sep 2013 14:13:52 -0400
Organization albasani.net
Lines 23
Message-ID <l2cf11$jgb$1@news.albasani.net> (permalink)
References <524759b8$0$52746$742ec2ed@news.sonic.net> <mstorkamp-96677F.08491729092013@news.eternal-september.org> <l29j4l$v8l$1@news.albasani.net> <524900ad$0$52757$742ec2ed@news.sonic.net>
Reply-To pjonescet@comcast.net
Mime-Version 1.0
Content-Type text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding 7bit
X-Trace news.albasani.net 9t9GBfoknafNkJW/zipbU31hbi4O1+ymm19atDfNh+ZpzeCpewR446ZEJsDkeom2dYXBd9YXneKDfS1LjvrVjQ==
NNTP-Posting-Date Mon, 30 Sep 2013 18:13:53 +0000 (UTC)
Injection-Info news.albasani.net; logging-data="3+RSDpLkjIwe8xuIQmks0LwEFZjCYs/Te3HkaxpQC/RuL6as/U++r/pRwxomMQduh5kvprK4EtnyboSM8WQvTx48uaXRs33vlYoVoFsOR9ROsvnNOS30bp0n9mtiMzxq"; mail-complaints-to="abuse@albasani.net"
User-Agent Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8; rv:24.0) Gecko/20100101 Firefox/24.0 SeaMonkey/2.21
In-Reply-To <524900ad$0$52757$742ec2ed@news.sonic.net>
Cancel-Lock sha1:aqUod8XtfiSLPsZdAi6vjD77Rjg=
Xref csiph.com comp.sys.mac.apps:17855

Show key headers only | View raw

Patty Winter wrote:
> In article <l29j4l$v8l$1@news.albasani.net>,
> PhillipJones  <pjonescet@comcast.net> wrote:
>>
>> As long as its individual numbers it will sort easily the complex number
>> will not sort the way you want.  See this Movie I created:
>> http://www.screencast.com/t/YGijcRL4d
>
> Yes, that's exactly the problem I encountered when I did those
> steps. The single numbers sorted fine, but the range ended up
> at the bottom. :-(
>
> Thank you for making that movie.
>
>
> Patty
>
Now if there are multiple Complex numbers they will be sorted as well 
but will fall to the bottom after all the single or simple numbers.

-- 
Phillip M. Jones, C.E.T.      "If it's Fixed, Don't Break it"
http://www.phillipmjones.net    mailto:pjonescet@comcast.net

Back to comp.sys.mac.apps | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Any way to get Excel to sort these numbers properly? patty1@sonic.net (Patty Winter) - 2013-09-28 22:35 +0000
  Re: Any way to get Excel to sort these numbers properly? Davoud <star@sky.net> - 2013-09-28 19:13 -0400
    Re: Any way to get Excel to sort these numbers properly? Patty Winter <patty1@wintertime.com> - 2013-09-29 00:14 +0000
      Re: Any way to get Excel to sort these numbers properly? Davoud <star@sky.net> - 2013-09-29 11:30 -0400
  Re: Any way to get Excel to sort these numbers properly? Lewis <g.kreme@gmail.com.dontsendmecopies> - 2013-09-29 01:56 +0000
    Re: Any way to get Excel to sort these numbers properly? Patty Winter <patty1@wintertime.com> - 2013-09-29 02:46 +0000
  Re: Any way to get Excel to sort these numbers properly? Mark Storkamp <mstorkamp@yahoo.com> - 2013-09-29 08:49 -0500
    Re: Any way to get Excel to sort these numbers properly? PhillipJones <pjonescet@comcast.net> - 2013-09-29 12:05 -0400
      Re: Any way to get Excel to sort these numbers properly? Patty Winter <patty1@wintertime.com> - 2013-09-30 04:40 +0000
        Re: Any way to get Excel to sort these numbers properly? PhillipJones <pjonescet@comcast.net> - 2013-09-30 14:13 -0400
        Re: Any way to get Excel to sort these numbers properly? Davoud <star@sky.net> - 2013-10-01 00:13 -0400
          Re: Any way to get Excel to sort these numbers properly? Patty Winter <patty1@wintertime.com> - 2013-10-01 05:14 +0000
    Re: Any way to get Excel to sort these numbers properly? Patty Winter <patty1@wintertime.com> - 2013-09-29 22:55 +0000

csiph-web