If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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. |
#12
|
|||
|
|||
Sorting by Date and Time
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 |
#13
|
|||
|
|||
Sorting by Date and Time
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. |
#14
|
|||
|
|||
Sorting by Date and Time
Pleasure', Plumstone !
-- Rgds Max xl 97 --- Please respond in thread xdemechanik atyahoodotcom ---- "plumstone" wrote in message ... Max, Thanks. Plumstone |
#15
|
|||
|
|||
Sorting by Date and Time
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 … |
|
Thread Tools | |
Display Modes | |
|
|