Or format empty cell as date before copying and do it in one fell swoop! <g

--

Regards,

Peo Sjoblom

"Niek Otten" wrote in message
...
Hi Sarjak,

Probably the 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 "Dates". 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

"sarjak" wrote in
message ...

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 formatcellsDATE03/01/05). When I select the
columns go to DATA SORT 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:
http://www.excelforum.com/member.php...o&userid=29402
View this thread:
http://www.excelforum.com/showthread...hreadid=496477