• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Date Formating

sachar

Member
Dear All,

With reference to the attach sample file, when I converted the file from PDF to Excel the date format returned in wrong format (Year become dated & Date become year) in [column”A”].

May I know how to convert into the proper date format like as mentioned in comments Box.
 

Attachments

  • DATE FORMAT_CHANGE.xlsx
    15.4 KB · Views: 13
Try,

Select A2:A68 >> "Data" >> "Text to Column" >> Choose "Delimited" >> Next >> Next >> Choose "Date" and select "YMD" from the right side dropdown list >> Finish.

Regards
 
sachar
1) Select A-Column
2) Format Cells to 'General'
3) Format Cells to 'Date'

oops! - that was in Mongolian-format!
Cell C2 = Year(A2)
Cell D2 = Month(A2)
Cell E2 = Day(A2)
Cell F2 = Date(2000+E2,D2,C2-2000)
=> format as needed
 
Last edited:
Back
Top