Excel Date Format issue

Hi Experts,

I have issue to change date format. I want to have dd/mm/yyyy   if month is 3 I want to display 03
please find attached file.

Thanx
M-Cycle-Closed-20141231-Modified-date-fo
a500505077Asked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
0
 
Saqib Husain, SyedEngineerCommented:
Format the data as per your requirement dd/mm/yyyy

Then select the data
Goto      Data > Text to columns
Click Finish
0
 
a500505077Author Commented:
Sallam Allukum  Saqib,

applied in some but not all, sorry for asking this would you mind upload fixed file.

Thank you.
0
 
a500505077Author Commented:
Big Thank you Saqib.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.