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...
Steve,
did you try text-to-columns?
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.
If text to column and for the cell F2->Enter both don't work when most probably dates are entered not in current regional settings format
