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
 
Top