Convert Numbers to Dates Using Excel VBA
|Home||More Excel (VBA) Training Videos|
|| A website visitor has thousnads
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: