Posted to microsoft.public.excel.misc

ezil

external usenet poster

Posts: 43

convert text to date

I have some text data like 26/10/2007 in a column which is extracted from web
page. I changed the format from text to date. Although it is in date format
real conversion does not takes place. When I am doing sorting operation it
sorts the data
as it is text value. How to convert the text data to date?

Reply With Quote

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
Convert Text to DATE	Dimmer	Excel Discussion (Misc queries)	8	January 22nd 09 01:15 PM
Convert date to text	Patrick C. Simonds	Excel Worksheet Functions	2	September 3rd 07 10:11 PM
how do i convert text to date (mm/yy text to mm/dd/yyyy date)?	lindsey	Excel Discussion (Misc queries)	1	July 27th 07 10:05 PM
convert text to date	scubadiver	Excel Discussion (Misc queries)	3	July 10th 07 11:08 AM
Help: How do I convert a text date into a real date format	japorms	Excel Worksheet Functions	4	August 2nd 06 06:36 PM

All times are GMT +1. The time now is 10:47 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us