Excel Error fix
Excel Dates Stored as Text: 4 Ways to Convert Them to Real Dates
Excel dates left-aligned, not sorting, or giving #VALUE!? Detect dates stored as text and convert them with DATEVALUE, Text to Columns, Paste Special or DATE+MID.
#text-to-columns
1 tutorial tagged “text-to-columns”.