Greg

Posts: n/a

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
pasting data from a website changes text to date	stebro	Excel Discussion (Misc queries)	8	August 12th 06 08:39 PM
Converting selected section of text to numbers	Rob	Excel Discussion (Misc queries)	6	March 8th 05 01:52 AM
Schedule rotaing with text and numbers	Trying to excel in life but need help	Excel Discussion (Misc queries)	0	March 4th 05 08:05 PM
I enter numbers and they are stored as text	burkeville	Excel Discussion (Misc queries)	5	December 3rd 04 01:59 AM
Converting text to numbers	Scott	Excel Discussion (Misc queries)	3	November 26th 04 09:17 PM

All times are GMT +1. The time now is 07:57 PM.

About Us

"It's about Microsoft Excel"