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

[Don Guillett]

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

 

[RagDyer]

OR -

=RIGHT(LEFT(A1,5))

 

[T. Valko]

=MID(A1,5,1)

That will return 3 as a TEXT value

=--MID(A1,5,1)

That will return 3 as a numeric value