Convert Text Dates M/D/Y or Y/M/D to Numeric Dates D/M/Y

Chester Tugwell
0
1939

This video demonstrates how to convert dates (that have been imported into Excel as text values) into proper numeric dates. The method will also work where the text dates are the wrong regional format eg US rather than UK or YYYY/MM/DD rather than DD/MM/YYYY. The method used is Text to Columns.

Published by: Chester Tugwell Published at: 4 years ago Category: چگونه
Microsoft Excel Dates Text Dates Convert dideo دیدئو text dates convert numeric دیدئو dideo method mdy ymd dmy video demonstrates imported excel values proper datesthe will work wrong regional format yyyymmdd ddmmyyyythe columns