Thread: convert string to number
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
  
Posts: 3,268
Default convert string to number
=--MID(...)

will work as long as you parse out a number with the MID function


--


Regards,


Peo Sjoblom


"Jeff Klein" <jklein@nospam wrote in message
...
I am extracting part of a string using Mid() and I need to convert this to
number format. Any ideas?



Reply With QuoteReply With Quote