[Whenever I try to sort data in the format shown Wkdy, Month Day, Year; it reverts to some alphabetical crap by the leftmost item. I have 2000+ items I have randomly placed in this column and I just need the thing sorted or a format that will make it work. This shouldn't be this difficult. Don't tell me I have to delete the weekday or place it last to make it work.
Last edited by mrsinnister; 03-23-2006 at 12:15 PM.
UPDATE: Dilemma
I had to manually key in the numeric equivalent of the date after formating the corresponding column. If there is a way to just convert text to numeric, in case it happens to someone else, they will appreciate your solution. Now I know better.
Have a look at Step 3 in the Data |Text to Column
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"mrsinnister" <[email protected]>
wrote in message
news:[email protected]...
>
> *-I had to manually key in the numeric equivalent of the date after
> formating the corresponding column. If there is a way to just convert
> text to numeric, in case it happens to someone else, they will
> appreciate your solution. Now I know better.-*
>
>
> --
> mrsinnister
> ------------------------------------------------------------------------
> mrsinnister's Profile:
> http://www.excelforum.com/member.php...o&userid=32737
> View this thread: http://www.excelforum.com/showthread...hreadid=525698
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks