Date Format Issue: Importing data into Excel 2007

Hi All,

I'm a newbie here so forgive me if my "best practices" of posting are incorrect - I gladly take constructive criticism!!

I regularly run a report from an online data repository that stores data about each IT asset I have on site. The repositry is based in the US meaning all the date formats are in M/D/Y. I would like to know is there a way to get the data from the repository and save it to Excel in the correct date format for UK.

I can save the data in a number of formats (CSV, Excel, PDF). I have tried using csv format and then using the text to colums wizard and selecting the Column Data Format for Date to D/M/Y but that still produces the dates in US format. I have also tried changing file to txt format and importing that way but it always stays in US format. Whwn I try and edit the cell format, it loses the date and puts random numbers in there instead.

I have attached a copy of the data in xls format (unable to add it in csv format) in a hope that someone can explain the best way to convert the dates to UK format...

Thanks in advance
Spud

After you've imported your date data, the easiest way to change the field is to click on F, then right-click, choose format cells, then custom format. Enter D/M/YYYY in the TYPE field and click OK.

If you're importing using a macro, add this before it posts your raw data.

Columns("F:F").Select
Selection.NumberFormat = "d/m/yyyy"