|Subject:||Text to Number?|
|Posted by:||Steve Almond (steve…@nildram.co.useless)|
|Date:||Thu, 16 Oct 2003|
When I copy data from a webpage into a spreadsheet, I often have an obvious
currency value (£36.40) but cannot operate on it with arithmetic functions
(say divide it by 2). I've tried using the VALUE() function without success.
Is there an answer?