How to transfer "text" into "date"?

L

lalann

Hi,

The dates shown in the report are in text format. As you can see below, it
is "DD-MM-YYYY". But as it's is in text format, I can't use it as "date" to
do the further analysis. Is there any ways to change the below text into
"date"? Thanks.

14-12-1969
26-12-1962
01-06-1960
29-05-1963
 
J

Jacob Skaria

Select the range. From menu Data>Text to columns>Next>Next will take you to
Step 3 of Wizard. Select Date and select the format (DMY) and hit finish.
Excel will convert this to date formats. Try and feedback

If this post helps click Yes
 
E

Eduardo

Hi,
I assumed your information is in column A, in column B enter

=DATE(VALUE(LEFT(A1,1)),VALUE(MID(A1,2,2)),VALUE(RIGHT(A1,2)))
 
L

lalann

Hi Jacob,
I am using Excel 2003. So I don't have this funtion. May I ask if there is
any other way to do it? Thanks.
 
L

lalann

Hi David,

Thanks. It works. I also find Text to columns in menu. (My excel is not in
English, so try to find what "Text to columns" is.:p)

Thanks all.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top