By entering the codes 123 or 4 times the display will be different. In Step 1 select Delimited -- our items have a space character that separates the date and time Click Next. The Excel TEXT function can also be used for formatting dates.
To convert the date into number format with the formula Date value.
MONTH followed by an opening bracket. This has been a guide to Date Format in Excel. The TEXT function takes two arguments as shown below. Press the Short Date or Long Date format.