convert string to number

J

Jeff Klein

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

T. Valko

Try one of these to convert the result of the MID function to a numeric
number.

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

=MID(........)+0
 
N

Niek Otten

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?
|
|
 
P

Peo Sjoblom

=--MID(...)

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


--


Regards,


Peo Sjoblom
 
P

Pete_UK

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
removing zeroes almost perfect 2
Convert Week number into Month 5
Convert worksheet string name to date format in cell 2
Convert WAV to MP3 4
cannot convert text string into value 16
Convert int ccyymmdd to date(time) 9

Top