- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2003 October
- Text to Number?

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

- Re: Text to Number? posted by Steve Almond on Fri, 17 Oct 2003
- Text to Number? posted by Don on Thu, 16 Oct 2003
- Re: Text to Number? posted by Ron de Bruin on Thu, 16 Oct 2003