Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel Date Format issue

Posted on 2014-12-31
4
Medium Priority
?
224 Views
Last Modified: 2015-01-01
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
0
Comment
Question by:a500505077
  • 2
  • 2
4 Comments
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 40526389
Format the data as per your requirement dd/mm/yyyy

Then select the data
Goto      Data > Text to columns
Click Finish
0
 

Author Comment

by:a500505077
ID: 40526393
Sallam Allukum  Saqib,

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

Thank you.
0
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 2000 total points
ID: 40526398
0
 

Author Closing Comment

by:a500505077
ID: 40526401
Big Thank you Saqib.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question