Dear Sir/Madam,
Need help. Want to change date format 25 Nov 14 12:00pm to dd-mm-yyyy in excel sheet. The same is attached for your needful. Thanks in advance. Best Regards,
Javed SaUsageReportMembers.xlsyed
Dear Sir/Madam,
Need help. Want to change date format 25 Nov 14 12:00pm to dd-mm-yyyy in excel sheet. The same is attached for your needful. Thanks in advance. Best Regards,
Javed SaUsageReportMembers.xlsyed
=LEFT(SUBSTITUTE(SUBSTITUTE(A2," ","-",1)," ","-",1),10)+0
and copy down the column
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Use this formula in B2:
=DATEVALUE(LEFT(A2,9))
Format that cell using a Custom Format of dd-mm-yyyy, then copy down.
Hope this helps.
Pete
Another approach......
Try this.....
and copy down.Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks