Forum Discussion
Date formatting error #################
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 selecti...
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)
Thank you so much! I was overlooking the obvious. That fixed the issue and I will be sure to make a note of it.