Text to Number?

Giganews Newsgroups
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?

Thanks,

Steve

Replies