Hi, Please help to fix this: I have a list of registration having mixed between numbers and text but excel (2007) automatically converted to date. I dont know how to convert it back to original text.
For example:
Name ID ---> Output
David C march27 27-Mar
Adam A 41008 (same number)
Ray R apr11 11-April
Cooper M 41015 41015
Ryan C may07 7-May
Darevic L jun2012 Jun-12
Yulinana B 7december 7-Dec
And it is very long list which I could not know original input of those names. So how could I use formulas to convert it back? Or how to get the original input?
Thanks in advance
For example:
Name ID ---> Output
David C march27 27-Mar
Adam A 41008 (same number)
Ray R apr11 11-April
Cooper M 41015 41015
Ryan C may07 7-May
Darevic L jun2012 Jun-12
Yulinana B 7december 7-Dec
And it is very long list which I could not know original input of those names. So how could I use formulas to convert it back? Or how to get the original input?
Thanks in advance