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?

Show all headers | 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