Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Excel Date Format issue

Posted on 2014-12-31
4
Medium Priority
?
235 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

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

579 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