Bluewave
Active member
- Messages
- 240
- Likes
- 2
Hi, I'm hoping some clever Excel bod can work this out!
I am using Excel's web query to import Yahoo financial data to be updated on a daily basis. When I use this link: http://uk.finance.yahoo.com/d/quotes.csv?s=^dji&f=d1&e=.txt
...the following is imported into an Excel cell: 04/20/2005 (ie. date at the time of import in mm/dd/yyyy format).
Now, how can I force this American date format into the preferred British format of dd/mm/yyyy? Simply using the date formatting tool does not work
presumably because the cell is a web query.
Any ideas?
I am using Excel's web query to import Yahoo financial data to be updated on a daily basis. When I use this link: http://uk.finance.yahoo.com/d/quotes.csv?s=^dji&f=d1&e=.txt
...the following is imported into an Excel cell: 04/20/2005 (ie. date at the time of import in mm/dd/yyyy format).
Now, how can I force this American date format into the preferred British format of dd/mm/yyyy? Simply using the date formatting tool does not work
Any ideas?