convert string to number

  • Thread starter Thread starter Jeff Klein
  • Start date Start date
J

Jeff Klein

I am extracting part of a string using Mid() and I need to convert this to
number format. Any ideas?
 
Try one of these to convert the result of the MID function to a numeric
number.

=--MID(........)

=MID(........)+0
 
Hi Jeff,

=VALUE(YourMidFormula)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am extracting part of a string using Mid() and I need to convert this to
| number format. Any ideas?
|
|
 
=--MID(...)

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


--


Regards,


Peo Sjoblom
 
Just multiply it by 1 (or add zero) as part of your formula:

=1*MID(A1,3,2)

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time elapsed calculation 6
Special string convertion to date and time 4
Convert Text to Number 5
Convert text numbers to numbers 4
How Do I Find Different Values In A String? 2
removing zeroes almost perfect 2
Extract a text string based on character 5
Converting from Decimal to Base-36 in Excel Formula 8

Back
Top