I have dates stored as text in the following format:
Mar 10, 2015
I want to convert it to a value stored as a date and display it formatted as yyyy-mm-dd:
2015-03-10
I initially tried to use the text to columns feature and parsed all the date components to separate cells. The idea was to then concatenate the cells with formatting that Excel would recognize as a date, such as =B1&"/"&A1&"/"&C1
to produce 10/03/2015
. However, Mar
requires translation to a month number.
For that matter, I could just concatenate as =C1&"-"&A1&"-"&B1 to get the desired appearance, but Excel treats the results of these string manipulations as text rather than a date.
How do I convert the original text to a date so I can use the Excel number format to display it as desired?