Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I get stock quotes in Excel without text?
Hi,
I have been spending a bit of time recently designing a spreadsheet to monitor my investments in the stock market. In doing this I have come to use the Office Refference tool a lot for gettting up to date stock quotes. In doing this it occurred to me that I could automatically update my spreadsheet using this tool, however when I do "Insert Price" into a cell, it displays text and numbers, e.g. "AUS:JST 2.07" which obviously doesnt work with formulas. Is there a way to get the Refference tool to insert only the "2.07" into a cell? Thanks in advance, -Simon |
#2
|
|||
|
|||
Hi,
Was just playing around with web queries and I think I've solved the problem! But if anyone does have any good suggestions (mine is a bit messy at the moment), I would love to hear from you. -Simon "m_man" wrote: Hi, I have been spending a bit of time recently designing a spreadsheet to monitor my investments in the stock market. In doing this I have come to use the Office Refference tool a lot for gettting up to date stock quotes. In doing this it occurred to me that I could automatically update my spreadsheet using this tool, however when I do "Insert Price" into a cell, it displays text and numbers, e.g. "AUS:JST 2.07" which obviously doesnt work with formulas. Is there a way to get the Refference tool to insert only the "2.07" into a cell? Thanks in advance, -Simon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need shortcut in Excel for coping text only and not the entire c | Excel Discussion (Misc queries) | |||
How to save an excel spreadsheet as a text file without added quot | Excel Discussion (Misc queries) | |||
How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
how do I enable "import text file" excel 2002? | Excel Discussion (Misc queries) | |||
How do I get real time stock quotes to my excel worksheet? | Excel Discussion (Misc queries) |