Cut/paste dates from web

  • Thread starter Thread starter justam
  • Start date Start date
J

justam

Hi

Wanting to cut and paste a table from web site.

Table dates are in format mm/dd/yy. My system format is dd/mm/yy.

Invalid dates for my system (Dec 13, 12/13/04) paste as text.

Valid dates (12/11/04, Dec 11) paste as date but 12 Nov.

Is there any way I can paste and have my system recoginise the mm/d
/yy as the correct date?

Paste special options do not seem to work
 
Hi, justam,

Can you put this in a side column to parse the order
of month & day?? :

=MID(B1,4,2)&"/"&LEFT(B1,2) & "/" & RIGHT(B1,4)

jeff
 
Jeff

Thanks for that. I was aware of that form of solution. Would work if
ALL the dates came across as text. However, those valid date come
across as a serial number, but for the wrong date.

I'll come up with something
 

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

date 2
extracting only month from a date 6
Preserving date format 1
Determine accuracy percentage between two dates 2
Weird date format problem 2
date format 1
Excel 2007 text import as text not date 3
Date Format 1

Back
Top