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?