Thread
:
Pick the 5th number out of the following number 1002300.
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
Posts: 15,768
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
...
Reply With Quote
T. Valko
View Public Profile
Find all posts by T. Valko
Pick the 5th number out of the following number 1002300.