| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pick the 5th number out of the following number 1002300.
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pick the low number in a column of Numbers | Excel Discussion (Misc queries) | |||
| How do I pick the only number in a column and copy it to another? | Excel Discussion (Misc queries) | |||
| FORMULA TO PICK NUMBER | Excel Worksheet Functions | |||
| I need to total col, but pick up number in other col. if not 0 | Excel Worksheet Functions | |||
| In Excel, I need to now how to pick the second highest number in . | Excel Worksheet Functions | |||
Linear Mode
