convert text to date

  1. E

    Converting imported text as dd/mm/yyyy to date as yyyymmdd

    I have an Excel macro which imports a csv file with all the fields specified as text. Among these fields is a field whith a date. This fields appears as dd/mm/yyyy. When it comes to copy this field to another sheet converting it to date format yyyymmdd and later sort on the fields it does not...
  2. R

    Strange Date Format 11/4/14, 1:09 PM will not convert to Excel Date Time due to comma placement

    A popular product has an Export to Excel with a single column for Date / Time. The format shown has the date [comma] Time. It won't convert to a Date date type due to the comma. A popular software tool takes this data off of the internet and converts it to this text string. I can manually use...
  3. C

    Issue converting string to number..

    I found a problem with my code where I was using CInt to convert string values into numeric. However, I have tried using CDbl and CLng and I still don't get the value. "27623" converts without issue, "72702" will not. Is there any way that makes sense?
  4. G

    How to convert text base date into xx/xx/xxxx format

    I have cells with dates in the format below <table width="200" border="0" cellpadding="0" cellspacing="0"><colgroup><col width="200"></colgroup><tbody><tr height="17"> <td class="xl24" style="height:12.75pt;width:150pt" width="200" height="17">Wed Jun 01 09:23:11 PDT 2011</td>...
  5. S

    Date Format query

    Hi I have below data which generates in skewed date format some come with 4 digit year and some with 02 Digit year . I am also unable to convert the Date Text into date . Tried all your earlier tips . I am using Excel 2003 would you be able to help in converting all in an uniform format ...
  6. S

    Convert inconsistenly formatted text to date

    I receive text inconsitently formatted text strings that I would like to convert to a date. The strings always have the date followed by a message. Unfortunately, the date comes in several different forms. The day can take one of four formats: not named, one letter, three letters, or...
  7. S

    Convert text to date

    Dear all, I am exporting data from an educational piece of software into excel but unfortunately it exports dates stroed as text. I am hoping that someone has an easy way to convert this text into a recognisable date format in excel. The file to download i here...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top