Date & Time Stored as Text- How to convert it to Date & Time format

**Naren_Kumar** · 02-06-2020, 09:50 AM

Hello All,

I've a file which has Date & Time Stored as Text - How to convert it to Date & Time format?

I've attached workbook for reference.

Thank you.

**Sam Capricci** · 02-06-2020, 10:01 AM

highlight the column, go to data tab, open text to columns and if it is on delimited just hit finish and they'll all convert.

**Naren_Kumar** · 02-06-2020, 10:04 AM

Thank you for the reply, I wanted a formula which can covert it dynamically.

Date & Time Stored as Text- How to convert it to Date & Time format

LinkBack

Thread Tools

Rate This Thread

Display

Date & Time Stored as Text- How to convert it to Date & Time format

Re: Date & Time Stored as Text- How to convert it to Date & Time format

Re: Date & Time Stored as Text- How to convert it to Date & Time format

Thread Information

Users Browsing this Thread

Similar Threads

Date and Time as Text but unable to convert to date and military time in separate columns

Convert Date and Time to Date - Format problems

[SOLVED] Text to Date, Convert to US Format from UK, Eliminate Time

Time stored as text. How can I convert to data and time?

Convert date and time in serial number format to text format

[SOLVED] How do I convert imported date/time data to date/time format?

Convert text to date time format

Bookmarks

Bookmarks

Posting Permissions