Forum Discussion
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...
yes I tried this but had no success.
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.
Unselect Formulas -> Show Formulas
- Brilliant!! I don't know why I didn't think of that. Thank you!
