Thread: How can I convert a character string that contains letters & numbers "£2,456.99 (including flights)" into a numeric?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ship ship is offline
external usenet poster
  
Posts: 10
Default How can I convert a character string that contains letters & numbers "£2,456.99 (including flights)" into a numeric?


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