Forum Discussion
Steve Swatsenbarg
Aug 08, 2017Copper Contributor
Changing text to date in excel 2013
This might seem pretty silly, but I can't seem to get cell with the date entered into it to convert from the text format to a date format. I've tried everything I can think of and nothing seems to w...
Steve Swatsenbarg
Aug 08, 2017Copper Contributor
yes I tried this but had no success.
Detlef_Lewin
Aug 08, 2017Silver Contributor
Did you use find-and-replace with character 160 - and then text-to-columns?
Did you use CLEAN(A1)*1?
Otherwise please provide a sample workbook.
- Steve SwatsenbargAug 08, 2017Copper Contributor
- SergeiBaklanAug 08, 2017Diamond Contributor
Unselect Formulas -> Show Formulas
- Steve SwatsenbargAug 08, 2017Copper ContributorBrilliant!! I don't know why I didn't think of that. Thank you!