Hi Everyone,
I am using Power Query to automatically download historical stock price data from Yahoo! Finance into Excel.
It populates a worksheet with a year's worth of stock prices with the following columns: Date/Open/High/Low/Close/Adj Close/Volume.
The problem is the data is recognized as text only. It isn't recognized as numbers. So it's worthless. How do I covert the text into data? Preferably without any complicated programming since I'm just a basic user.
I uploaded a copy of my workbook.
Thanks,
Sam
Bookmarks