Date formatting error #################

[RoanMare]

I have tried Data > Text to Columns and converted the text to number and then tried changing the following dates to 01/03/23. I have tried other solutions but all I get is ############## when selecting the date format.

Is there another solution? The info was downloaded from a BI report.

Date
20230103
20230103
20230104
20230104
20230104
20230105
20230105

[#2]

@RoanMare 

Excel doesn't recognize 20230103 as a date.

Select the column, then click Text to Columns again.

Select Delimited, then click Next > twice.

Select YMD from the drop down next to Date.

Click Finish.

(Make sure that the column is wide enough to display a date)

[#3]

Thank you so much! I was overlooking the obvious. That fixed the issue and I will be sure to make a note of it.