Donate SIGN UP
Home > Technology > sorting on xcel worksheet

sorting on xcel worksheet

Avatar Image
BJS | 20:30 Tue 22nd Aug 2006 | Technology
2 Answers
I am trying to sort a 3 column table where the 1st column is the date i.e. 22.08.06 by going to DATA- SORT as normal but when I try to sort it by DATE it sorts by the DAY date only and not by the DAY/MTHYEAR as I want it to. Any help woud be appreciated.
prev I have just aquired an ipod
  
next laptops
Gravatar

Answers

1 to 2 of 2rss feed

Best Answer

No best answer has yet been selected by BJS. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Avatar Image ugly_bob
highlight the first column, then go into
Format -> Cells
The first tab is 'number', choose 'date from the list. This should help, alhtough it should do it automatically.
You may need to enter the dates as 22/08/06 rather than 22.08.06 though
22:59 Tue 22nd Aug 2006
Avatar Image Ralph
You could format the date as just plain numbers, sort by these numbers, then reformat as dates again.
21:27 Wed 23rd Aug 2006

1 to 2 of 2rss feed

Do you know the answer?

sorting on xcel worksheet

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.