New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Help pls. How to change a year value is series of data?

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Help pls. How to change a year value is series of data?

Postby Bronek536 » Wed Jun 08, 2016 5:38 am

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 :-)
  • 0

Bronek536
Rookie
 
Posts: 2
Joined: Jun 8, 2016
Reputation: 0
Excel Version: 2013

Re: Help pls. How to change a year value is series of data?

Postby Bronek536 » Wed Jun 08, 2016 6:41 am

Solved now =--(TEXT(A1,"dd/mmm")&"/2015")
  • 0

Bronek536
Rookie
 
Posts: 2
Joined: Jun 8, 2016
Reputation: 0
Excel Version: 2013


Return to General Excel Questions

Who is online

Users browsing this forum: Google [Bot] and 66 guests