A website visitor has thousands of numbers like 090203 which she wishes to convert to dates because her boss has given her the task. Now she finds that doing this manually is consuming too much of her time. How can we help her?
We have used the looping process along with a few text functions like left, mid and right to extract the appropriate data for the month, day and year and then formatted the text to dates. The process is completely automated and makes the conversion of the numbers into text quick and easy.
Watch the Excel training video below to see how you can convert the text data into dates automatically using Visual Basic for Applications in Excel: