Convert numbers to date

[jayemoh77]

Hello all-
I have a long row of dates formatted as 'general' that looks like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD]20170329[/TD]
[/TR]
</tbody>[/TABLE]
How can I fix it to read:
03/29/2017

Thank you!
Julie

 

[Weazel]

Maybe...

=TEXT(A2,"0000-00-00")+0 formatted as a date

 

[Joe4]

Highlight the column
Select "Text to Columns" from the Data menu
Hit Next until you get to Step 3
Choose the Date radio button option, and choose the YMD date format
Click Finish

It is now a date, and you can apply any date format you desire to that column.
(No formulas, VBA, or helper columns needed!).

 

[JoeMo]

Another way, if your numbers are always 8 digits:

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

 

[jayemoh77]

YOU ARE AWESOME! Thanks a billion!