Sorting by Date and Time

Thanks for all of you.
It works!!!
Plumstone

"plumstone" wrote:

I transformed some data to an excel file. I tried to sort those data by date and time, however it didn’t work. I also tried to change the format of the date to like “mar 2 98� or “03/02/98�, but the appearance is always “3/2/98�. It just refuse to change the format. It would be appreciated if anybody could help with this.

Always glad to hear that !
Thanks for the feedback ..
--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik atyahoodotcom
----
"plumstone" wrote in message
...
Thanks for all of you.
It works!!!
Plumstone

Max,
Thanks.
Plumstone

"Max" wrote:

Perhaps try Data Text to columns on the column with the "dates"?

Suppose these are all in col A, A1 down

Select column A

Click Data Text to columns

Click Next Next to get to step 3 of the wizard

Under Column data format:
Check the button for "Date"
(the drop arrow should show "DMY"
- this is what your data looks to be like)

Click Finish

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik atyahoodotcom
----
"plumstone" wrote in message
...
It is just the same of the natural appearance of the cell: "5/7/04" in the
sample area.
If I type some new data in that cell like:"05/07/04", then in the sample
area it shows 38110. And the date is going to return to normal and I can
sort them by date and time or change to any format I want.
But I do not want to retype all of those date and time and I want to sort
them in date, while it refuseds to be either changed in format nor sorted by
date and time.

"JulieD" wrote:

Hi

when you right mouse click on one of the cells, go into format / cells &
choose the number tab, click on general ... what does it say under the
word
sample on the right hand side?

Cheers
JulieD

"plumstone" wrote in message
...
I transformed some data to an excel file. I tried to sort those data
by
date and time, however it didn't work. I also tried to change the format
of
the date to like "mar 2 98" or "03/02/98", but the appearance is always
"3/2/98". It just refuse to change the format. It would be appreciated
if
anybody could help with this.

Pleasure', Plumstone !
--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik atyahoodotcom
----
"plumstone" wrote in message
...
Max,
Thanks.
Plumstone

Because data in these cells are text type, so you couldn't sort it. You need
convert them to date-time type.
You could download the third party tool: AddinTools Assist from
http://www.addintools.com. It include several functions. One of these
functions is convert data of cells to text/number/date-time type.
It can convert data of all formats to text type.
It can recognize these formats as following and convert to date-time type:
2003.1.2, 2003.1.2 11:12:13:14PM, 2003-1-2, 2003-1-2 11:12:13.14PM,
20030102, 20030102 11:12:13:14PM, and locale format on your computer, and so
on …