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

--
Biff
Microsoft Excel MVP


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

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

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

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

=1*MID(A1,3,2)

Hope this helps.

Pete

On Nov 1, 9:44 pm, "Jeff Klein" <jklein@nospam wrote:
I am extracting part of a string using Mid() and I need to convert this to
number format. Any ideas?