Thread: How can I convert a character string that contains letters & numbers "£2,456.99 (including flights)" into a numeric?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
  
Posts: 2,574
Default How can I convert a character string that contains letters & numbe
http://www.ozgrid.com/VBA/ExtractNum.htm
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"ship" wrote:



Hi

How do I convert a string that contains letters and numbers
into a number using Excel2003 (or ms Access)

e.g. "£2,456.99 (including flights)"

== needs to be converted into the the numeric 2456.99

With thanks


Ship
Shiperton Henethe


Reply With QuoteReply With Quote