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

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

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

Show all headers | View raw

Davoud:
> >Yes. He can enter the numbers as text. He has only to type an
> >apostrophe in front of the numbers that do not include a range:
> >
> >'41200
> >'41201
> >41202-41206
> >'41207
> >'41208
> >41209-41211
> >'41202
> >...
> >
> >Excel will not show the apostrophe in the cell, but it will be visible
> >in the formula bar. Excel will automatically treat the ranges such as
> >41202-41206 as text. Then he can select the entire range of cells that
> >he wants to sort and select the catalog number column as the sorting
> >column (in ascending order, with "No Header Row" selected) and
> >everything will fall into place. 

Patty Winter:
> Okay, I don't know what I did wrong, but of the five cells that I
> sorted, the one cell that has a range still ended up below the four
> cells that have single numbers.

Davoud:
> >After the sort, with all cells still
> >selected, there will be a yellow warning icon adjacent to the first
> >cell. He should click on that warning icon. The message will be "Number
> >Stored as Text," and there will be options below that message. He
> >should select the option "Error Checking Options" and in the dialog box
> >that opens /uncheck/ "Flag numbers formatted as text." 

Patty Winter:
> I did that and it got rid of the little green triangles in the cells,
> but the one anomalistic number is still by itself at the bottom of
> the list. :-(

I'm sorry that I can't help from afar. I have tried this repeatedly and
it works for me every time.

-- 
I agree with almost everything that you have said and almost everything that
you will say in your entire life.

usenet *at* davidillig dawt cawm

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