Datetime text to Datetime Date

**stribor40** · 11-19-2021, 03:12 PM

Hi

I am having troubles converting data in column A to datetime. I tried using datevalue function, value function, text to column to no luck. I also tried adding number to A2 (=A2+0) in hope that will convert it to number but that didnt work.
I also tried some formulas I found online but all I keep getting is #VALUE! error.

Can anyone explain what I am doing wrong please.

Thanks

**MrShorty** · 11-19-2021, 03:26 PM

I did not have any trouble using text to columns to convert those to date numbers. If I had to guess, I would suspect that your computer system is set to a DMY default, that prevents Excel from automatically recognizing the date portion of the time stamp. Try using Text to columns again. At the appropriate step, be sure to explicitly specify MDY as the input date type to override any default system settings that Excel might be using.

**stribor40** · 11-19-2021, 03:37 PM

you were right. I had to change date format on my Windows 10 machine. Thank you

**Czeslaw** · 11-20-2021, 04:44 AM

Text io columns-->Next--->Space--->Finish
Text io columns-->Next--->Next--->DMY--->Finish

Datetime text to Datetime Date

LinkBack

Thread Tools

Rate This Thread

Display

Datetime text to Datetime Date

Re: Datetime text to Datetime Date

Re: Datetime text to Datetime Date

Re: Datetime text to Datetime Date

Thread Information

Users Browsing this Thread

Similar Threads

Count If Start Datetime and End Datetime is less than 30 seconds

[SOLVED] Move all files in a folder to a new folder it datetime less the latest datetime

Converting DateTime to Date

[SOLVED] Datetime to date and time

if statement for datetime value between two other datetime values

Converting Datetime in text to date format

Based on a Column datetime value auto calculate and populate a datetime range

Bookmarks

Bookmarks

Posting Permissions