Excel Tip: Convert Numbers to Dates with Text to Columns

Text to Columns wizard in Excel is often used to split a single column of text into multiple columns. But what most people do not know is that it can be used to convert a date represented in numbers into a formatted date.

For instance, 20220219 (YMD) can be converted into 2/19/2022. Hence, it can be used in formatting cells in addition to splitting text.

Follow the steps in this video to see how to leverage the Text to Columns beyond what its name says.

Comments

No comments yet. Why don’t you start the discussion?

Leave a ReplyCancel reply