• 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.

change date format from MM/DD/YYYY to DD/MM/YYYY

J

Jerald

New Member
Hi All

Please tell me how to change date format from MM/DD/YYYY to DD/MM/YYYY.
 

Attachments

  • sample.xlsx
    7.6 KB · Views: 8
Use text to column feature of excel and then use DATE() to combine various components into date and format ad DD/MM/YY.
 
Hi

Adding Text to Columns steps (as advised above)
  • Select your range (B2:B18)
  • Go to Data
  • Text to Columns
  • Select Delimited
  • Hit Next
  • Hit Next
  • Select Date
  • Select MDY
  • Hit Finish
After that format the cells as DD/MM/YYYY

Regards,
 
You must log in or register to reply here.
Back
Top