Date stored as Text

A

Andibevan

Hi All,

I am cetting an exchange rate table from an American Website. It uses the
american date format mm/dd/yyyy

As my PC is set-up to use the UK date format dd/mm/yyyy these dates are
stored as text when pasted to excel.

How would I convert these american dates to UK dates?

Thanks

Andi
 
G

Guest

Hi
Use Data|Text to columns.
Select your column of dates, click on Data|Text to columns and on the third
page of the dialog there is an option to tell Excel that the text is a
date - and the format of it (mmddyy, etc)
Save a copy of your data before you start!
 
A

Andibevan

Fantastic - Thanks Andy

<Andy B> wrote in message Hi
Use Data|Text to columns.
Select your column of dates, click on Data|Text to columns and on the third
page of the dialog there is an option to tell Excel that the text is a
date - and the format of it (mmddyy, etc)
Save a copy of your data before you start!
 

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

Convert dates stored as text 2
Date Formats 1
Preserving date format 1
Excel 2007 displayed dates 2
Excel - convert dates to text but appear as a date format 6
Date Conversion 4
Changing date to eliminate day in format mm/dd/yyyy 1
Formatting Dates from Text to Numbers 2

Top