Hi guys I hope someone here can help me with this.
I have used online ocr(Optical Character Recognition) software to convert picture table to excel format.
And it has done great job. My problem is with date's series. Original file contained data in dd/mmm format(eg. 01/Sep).
Excel automatically added to data 1900 year at the end. Original data is from 2015. Is there any formula or something to change last bit of the date from (eg. 01/Sep/1900 to 01/Sep/2015). I have got a year of data so need something. Thanks in advance