LinkBack URL
About LinkBacks
Dear All,
I copied some data from website and pasted it to excel sheet. Now excel do not consider date as date (Column A) and I am not able to do any calculation on date. Attaching excel file for reference.
Thank you,
PN
Dear All,
I copied some data from website and pasted it to excel sheet. Now excel do not consider date as date (Column A) and I am not able to do any calculation on date. Attaching excel file for reference.
Thank you,
PN
You can use text to columns wizard on Column A and set date as MDY paramater in step 3 for celformat that will convert the textdates to real dates..
Formula for H2 and fill down. =(MID(A2,5,2) &"/"&LEFT(A2,3)&"/"&RIGHT(A2,4))*1 Format H2 as Date.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Sorry Man. your solution is also working. Sorry.
PN
Roel Jongman your advice worked.
mehmetcik not able to get result.
Thank you both of you.
PN
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks