Pick the 5th number out of the following number 1002300.
 

e: Pick the 5th number out of the following number 1002300.R
 

Pick the 5th number out of the following number 1002300.R

Always use a short descriptive subject line and always put the question in
the body of the email or the archives wont see it

'

Look in the help index for MID

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mojo" wrote in message
...

Pick the 5th number out of the following number 1002300.
 

=MID(A1,5,1)

That will return 3 as a TEXT value

=--MID(A1,5,1)

That will return 3 as a numeric value

--
Biff
Microsoft Excel MVP


"Mojo" wrote in message
...