Thread: convert string to number
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default convert string to number
Hi Jeff,

=VALUE(YourMidFormula)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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