software

Hello all,

I am working with a 5 column/35 line spreadsheet and need to sort the
contents by date (column E). I have made sure that the column is
formatted for date (ex formatgt;cellsgt;DATEgt;03/01/05). When I select the
columns go to DATA gt; SORT gt; Column e ascending it sorts up until line
30 or so then it just does the willy nilly thing. I cannot figure out
why this simple function is giving me more greys. Any ideas?

Thanks
Tracy
--
sarjak
------------------------------------------------------------------------
sarjak's Profile: www.excelforum.com/member.php...oamp;userid=29402
View this thread: www.excelforum.com/showthread...hreadid=496477I'd be suspicious that some of your 'dates' are acutally text values
masquerading as dates.

Check the ones that don't sort correctly, maybe even re-entering them. Then
try sorting them again

quot;sarjakquot; wrote:

gt;
gt; Hello all,
gt;
gt; I am working with a 5 column/35 line spreadsheet and need to sort the
gt; contents by date (column E). I have made sure that the column is
gt; formatted for date (ex formatgt;cellsgt;DATEgt;03/01/05). When I select the
gt; columns go to DATA gt; SORT gt; Column e ascending it sorts up until line
gt; 30 or so then it just does the willy nilly thing. I cannot figure out
gt; why this simple function is giving me more greys. Any ideas?
gt;
gt; Thanks
gt; Tracy
gt;
gt;
gt;
gt; --
gt; sarjak
gt; ------------------------------------------------------------------------
gt; sarjak's Profile: www.excelforum.com/member.php...oamp;userid=29402
gt; View this thread: www.excelforum.com/showthread...hreadid=496477
gt;
gt;

Dear Sarjak

I'd recommend using a different feature.

Try auto filtering on your header row

Data --gt; Filter --gt; Autofilter

This will give you a little more control over sorting your columns. It's an
easy and quick feature.

Let me know if you still have the same problem sorting it this way.
quot;sarjakquot; wrote:

gt;
gt; Hello all,
gt;
gt; I am working with a 5 column/35 line spreadsheet and need to sort the
gt; contents by date (column E). I have made sure that the column is
gt; formatted for date (ex formatgt;cellsgt;DATEgt;03/01/05). When I select the
gt; columns go to DATA gt; SORT gt; Column e ascending it sorts up until line
gt; 30 or so then it just does the willy nilly thing. I cannot figure out
gt; why this simple function is giving me more greys. Any ideas?
gt;
gt; Thanks
gt; Tracy
gt;
gt;
gt;
gt; --
gt; sarjak
gt; ------------------------------------------------------------------------
gt; sarjak's Profile: www.excelforum.com/member.php...oamp;userid=29402
gt; View this thread: www.excelforum.com/showthread...hreadid=496477
gt;
gt;

Hi Sarjak,

Probably the gt;30 cells are text, not dates/numbers although they may look
like dates and are formatted as such.
You can easily check with the ISNUMBER() function. If so, do the following:
Format an empty cell as number. Copy. Select your quot;Datesquot;. Paste special,
check Add. Re-format as date.

BTW, 03/01/95; is that January or March?
You don't happen to expect the column to sort just on day, do you?

--
Kind regards,

Niek Otten

quot;sarjakquot; gt; wrote in
message ...
gt;
gt; Hello all,
gt;
gt; I am working with a 5 column/35 line spreadsheet and need to sort the
gt; contents by date (column E). I have made sure that the column is
gt; formatted for date (ex formatgt;cellsgt;DATEgt;03/01/05). When I select the
gt; columns go to DATA gt; SORT gt; Column e ascending it sorts up until line
gt; 30 or so then it just does the willy nilly thing. I cannot figure out
gt; why this simple function is giving me more greys. Any ideas?
gt;
gt; Thanks
gt; Tracy
gt;
gt;
gt;
gt; --
gt; sarjak
gt; ------------------------------------------------------------------------
gt; sarjak's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29402
gt; View this thread: www.excelforum.com/showthread...hreadid=496477
gt;

*Thank you* all for your responses.
The Autofilter didn't work.
And the field quot;seemedquot; to be formatted as a date/number.
I re-entered it and tried AGAIN and low and behold it worked.

Thanks again for all the input!

TracyBTW: 03/01/05 is March 1--
sarjak
------------------------------------------------------------------------
sarjak's Profile: www.excelforum.com/member.php...oamp;userid=29402
View this thread: www.excelforum.com/showthread...hreadid=496477Or format empty cell as date before copying and do it in one fell swoop! lt;ggt;

--

Regards,

Peo Sjoblom

quot;Niek Ottenquot; gt; wrote in message
...
gt; Hi Sarjak,
gt;
gt; Probably the gt;30 cells are text, not dates/numbers although they may look
gt; like dates and are formatted as such.
gt; You can easily check with the ISNUMBER() function. If so, do the
following:
gt; Format an empty cell as number. Copy. Select your quot;Datesquot;. Paste special,
gt; check Add. Re-format as date.
gt;
gt; BTW, 03/01/95; is that January or March?
gt; You don't happen to expect the column to sort just on day, do you?
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;sarjakquot; gt; wrote in
gt; message ...
gt; gt;
gt; gt; Hello all,
gt; gt;
gt; gt; I am working with a 5 column/35 line spreadsheet and need to sort the
gt; gt; contents by date (column E). I have made sure that the column is
gt; gt; formatted for date (ex formatgt;cellsgt;DATEgt;03/01/05). When I select the
gt; gt; columns go to DATA gt; SORT gt; Column e ascending it sorts up until line
gt; gt; 30 or so then it just does the willy nilly thing. I cannot figure out
gt; gt; why this simple function is giving me more greys. Any ideas?
gt; gt;
gt; gt; Thanks
gt; gt; Tracy
gt; gt;
gt; gt;
gt; gt;
gt; gt; --
gt; gt; sarjak
gt; gt; ------------------------------------------------------------------------
gt; gt; sarjak's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=29402
gt; gt; View this thread:
www.excelforum.com/showthread...hreadid=496477
gt; gt;
gt;
gt;