Posted to microsoft.public.excel.worksheet.functions

via135

external usenet poster

Posts: 94

CONVERSION OF TEXT TO DATE

How can I convert list of dates which are in text format in a mixed manner into date format "dd-mm-yyyy"

example:

Col A Col B

01.04.2013 01-04-2013
2.5.2013 02-05-2013
11.6.13 11-06-2013
9.7.2013 09-07-2013
01.8.2013 01-08-2013

In "Col A" the list and what I expect is in "Col B"

Please help.

Regards.

-via135

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
Text To Date Conversion	John Calder	New Users to Excel	2	March 9th 10 10:49 PM
Date to Text conversion	Michael Koerner	Excel Programming	10	July 30th 09 08:46 PM
Date to text conversion	Toke	Excel Discussion (Misc queries)	1	August 22nd 08 10:44 AM
Date to text conversion	ginnyst	Excel Discussion (Misc queries)	4	December 7th 07 03:32 PM
text to date conversion	samuel	Excel Worksheet Functions	3	August 17th 07 02:23 AM

All times are GMT +1. The time now is 06:54 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us