Hello,

I have imported stock quotes into Excel using a web query (Data, Import
External Data, New Web Query, etc ..). The field containing the stock
quotes is output as text, and contains the currency symbol (see
attached - column D). In order to try and use this data in formulas, I
have tried to convert it into numbers, by:
1. removing the currency symbol (Data, Text to Columns, ..) - see
column J in attached
2. convert the remaining data to number by using any of the methods
proposed by Microsoft and others, all of which failed to work.

Sample spreadsheet is attached. I'd be very grateful to anyone who
tries to help :).

Thanks


+-------------------------------------------------------------------+
|Filename: Sample.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4551 |
+-------------------------------------------------------------------+

--
pago
------------------------------------------------------------------------
pago's Profile: http://www.excelforum.com/member.php...o&userid=32990
View this thread: http://www.excelforum.com/showthread...hreadid=528189