Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CONVERSION OF TEXT TO DATE
Hi,
Am Tue, 22 Mar 2016 04:14:03 -0700 (PDT) schrieb via135: 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 try it with Text to columns. In step 3 choose Date "DMY" and then format the dates as expected. Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CONVERSION OF TEXT TO DATE
On Tuesday, 22 March 2016 16:44:09 UTC+5:30, via135 wrote:
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 Thanks.!!!! -via135 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CONVERSION OF TEXT TO DATE
"via135" wrote in message ... On Tuesday, 22 March 2016 16:44:09 UTC+5:30, via135 wrote: 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 Thanks.!!!! -via135 Try this: (Works with Excel 2010, should work with all others?) Highlight the text that you want converted select Find & replace, choose replace Find "." and replace with "-" in the replace with section, choose format choose number with custom category Under "type" enter mm-dd-yyyy Ok then select replace all. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text To Date Conversion | New Users to Excel | |||
Date to Text conversion | Excel Programming | |||
Date to text conversion | Excel Discussion (Misc queries) | |||
Date to text conversion | Excel Discussion (Misc queries) | |||
text to date conversion | Excel Worksheet Functions |