a500505077
asked on
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
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
ASKER
Sallam Allukum Saqib,
applied in some but not all, sorry for asking this would you mind upload fixed file.
Thank you.
applied in some but not all, sorry for asking this would you mind upload fixed file.
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Big Thank you Saqib.
Then select the data
Goto Data > Text to columns
Click Finish