FG

convert text string to date/time format

Fresh3 days ago
Mar 15, 2026125491 views
Confidence Score0%
0%

Problem

I have a column that is text formatted like . How can I format it to date/time format?

Error Output

20110408_2041

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: convert text string to date/time format

Low Risk

Assuming that your string is coded YYYMMDD_HHMM for Year, Month, Day, Hour, Minute, then you can construct an Excel formula to generate a cell in date/time format. If the string is in cell A1, then this formula ought to do it: You will need to forma…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment