How to convert "10/11/2013 17:29" into "dd" format in excel

Question

0.00/5 (No votes)

See more:

Hai friends,

I have date column in excel file that contains dates in the format "10/11/2013 17:29". I have to convert the above format into dd (ie)only date.How can I do this.Please help me.

Thanks in advance

Posted 24-Nov-13 18:49pm

Member 10234093

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Garth J Lancaster · Answer 1 · 2013-11-24T19:03:00

Solution 1

not sure I understand your problem

Excel has a formula/function for this - go to the cell you want the (dd) in and type

=DAY(D3)

where D3 is the cell with your long date in

Is that what you were looking for ?

Posted 24-Nov-13 19:03pm

Garth J Lancaster

Comments

Member 10234093 25-Nov-13 1:10am

It is not converting into dd

Thomas ktg · Answer 2 · 2013-11-24T19:09:00

Solution 2

Here you go.

1. Right click on the selected cell.
2. You will find Format Cells... in that.
3. Click on the Format Cells and then select Custom Category from the Number tab and type format you want in window.
if you want only dd then type as dd or any other format finally click on ok button.

Posted 24-Nov-13 19:09pm

Thomas ktg

Comments

Member 10234093 25-Nov-13 1:14am

THANKS.SUPPOSE IF WE WANT TO USE IN CSV FORMAT HOW IT CAN BE POSSIBLE

Thomas ktg 25-Nov-13 1:21am

I am not sure about .csv format. You try saving the file into .csv format.