How to convert any number series in date format ?
Converting year/month/date format in date/month/year or other format using excel formulas . Actually i was facing problem regarding the format of dates. The spreadsheet that i downloaded from my stock broker was having different format from what i wanted to have, for income tax filing purpose. The data was in following manner and i had tried number format option multiple times and it was not working at all. BuyDate SellDate 20161125 20161125 20160708 20160708 20160627 20160627 20160704 20160704 20160630 20160630…
Post to Tumblr