How do I change a date in 19950428 to 4/28/1995 in excel?
I have a data as show below in excel with column F having a different date format yyyymmdd as text.
For example 19900216. I need it to be in this format 2/16/1990
Any help I could would be appreciated.