Convert text to date

**sohaila** · 06-28-2017, 05:32 AM

please help I want to convert date '07-Oct-2016 to 07-oct-2016
thanks

**Pete_UK** · 06-28-2017, 05:40 AM

Assuming that text date is in A2, you can use this formula in cell B2:

=DATEVALUE(A2)

Format as a date in the style you prefer, then copy down as required.

Hope this helps.

Pete

Convert text to date

LinkBack

Thread Tools

Rate This Thread

Display

Convert text to date

Re: Convert text to date

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Convert a Text String Date to Date Serial Number

[SOLVED] How to convert exported text date to desired date format with excel vba.

[SOLVED] Use VBA to run "text to columns' Loop on first row to convert from text to date format

Formula to convert text to a date in a date format

Convert date in numbers to date in text, then translate into Spanish

convert a text date into a proper date

Help: How do I convert a text date into a real date format

Bookmarks

Bookmarks

Posting Permissions