Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Converting Text months to sortable Numbers or Dates
I have a column with months as text (April, etc.). Trying to sort them in
order, is there a way to convert them to dates or numbers in order to sort |
#2
|
|||
|
|||
Hi Greg-
No need to convert... Click in that column, then go to DataSort & click the Options button. Open the 'First key sort order' list and choose appropriately, the click OK in each box. HTH |:) "Greg" wrote: I have a column with months as text (April, etc.). Trying to sort them in order, is there a way to convert them to dates or numbers in order to sort |
#3
|
|||
|
|||
That works well when I have the months as the first sort key, however I
didn't mention that I also have a year column and would like to use that as the first key...I don't see a way to do that with months as the second key. Is there another way Thanks! "CyberTaz" wrote: Hi Greg- No need to convert... Click in that column, then go to DataSort & click the Options button. Open the 'First key sort order' list and choose appropriately, the click OK in each box. HTH |:) "Greg" wrote: I have a column with months as text (April, etc.). Trying to sort them in order, is there a way to convert them to dates or numbers in order to sort |
#4
|
|||
|
|||
Hi Greg-
Thanx fer the fly in the ointment! :) If the Year column is somewhere to the left of the Month cloumn, Sort by year first using the A-Z button, then sort by Month using the DataSort method. HTH |:). "Greg" wrote: That works well when I have the months as the first sort key, however I didn't mention that I also have a year column and would like to use that as the first key...I don't see a way to do that with months as the second key. Is there another way Thanks! "CyberTaz" wrote: Hi Greg- No need to convert... Click in that column, then go to DataSort & click the Options button. Open the 'First key sort order' list and choose appropriately, the click OK in each box. HTH |:) "Greg" wrote: I have a column with months as text (April, etc.). Trying to sort them in order, is there a way to convert them to dates or numbers in order to sort |
#5
|
|||
|
|||
BTW- Year doen't have to be to the left... too much Access lately.
Regads |:) "CyberTaz" wrote: Hi Greg- No need to convert... Click in that column, then go to DataSort & click the Options button. Open the 'First key sort order' list and choose appropriately, the click OK in each box. HTH |:) "Greg" wrote: I have a column with months as text (April, etc.). Trying to sort them in order, is there a way to convert them to dates or numbers in order to sort |
#6
|
|||
|
|||
That works! Sort by month and day using the first key option then by year
using the A/Z button. Cool, thanks! "CyberTaz" wrote: BTW- Year doen't have to be to the left... too much Access lately. Regads |:) "CyberTaz" wrote: Hi Greg- No need to convert... Click in that column, then go to DataSort & click the Options button. Open the 'First key sort order' list and choose appropriately, the click OK in each box. HTH |:) "Greg" wrote: I have a column with months as text (April, etc.). Trying to sort them in order, is there a way to convert them to dates or numbers in order to sort |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pasting data from a website changes text to date | Excel Discussion (Misc queries) | |||
Converting selected section of text to numbers | Excel Discussion (Misc queries) | |||
Schedule rotaing with text and numbers | Excel Discussion (Misc queries) | |||
I enter numbers and they are stored as text | Excel Discussion (Misc queries) | |||
Converting text to numbers | Excel Discussion (Misc queries) |