I have a date 51231 (2005,dec,31) -I want to change to 2005/12/31

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a bunch of date with dates entered as 51231 for (2005/dec/31), I want
to convert these numbers into date format 2005/12/31, any suggestions,
please...

thanks in advance,

cd
 
=DATE(2000+LEFT(A1,1),MID(A1,2,2),RIGHT(A1,2))

Then...
<Format>
<Cells>
"Custom" tab
Enter: yyyy/mm/dd
 
WOW,

I love this sight! You just made my dd, mm, yyyy! - thanks a ton.

cd
 
How about

=DATEVALUE("200"&TEXT(A1,"0-00-00"))

and format as a date

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
You must log in or register to reply here.

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

Similar Threads

Problem formatting dates from CSV file 2
Using if statements with a date 6
The death of music TV channels in UK - but not Europe? 4
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Lookup closest to 5
If statements?? 2
date formula assistance req'd 5
Calculate Days Left in Current Year 3

Back
Top