Hi, thanks you all for helping.
Hi NARAYANK991, the file I got is in .csv format which was generated from website. I tried to set format for the column A (IDs), and text to columns function was activated. But there were few lines falling on the wrong colums... Anyway, I think you are right...
Hi, thank you all for your advice. And gracias SirJB7! But I think I did not make my concern clearly. Let me elaborate it again: I have a list of IDs containing alphanumeric entries and only numberic entries which are unique (date is an invalid ID). The problem is excel automatically converted a...
It is a yes to all your questions. I already tried those tips:
1. Set to General: it would be displayed "40991", which is not actual ID
2. Set it to Custom format: "mmmd", which is correct for only "march27" nut not correct for "jun2012" and "7december". And please be noted that I have a very...
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...