| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text string to a number
The following function returns a text..but i want to get it as a number:
Public Function Gmid(vin) If Mid(vin, 12, 1) < "A" And Mid(vin, 12, 1) 0 Then ID = Right(vin, 6) Else ID = Right(vin, 5) End If Gmid = ID End Function Thanks in advance x your help! AhsMorK (chile) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Text string to a number
Public Function Gmid(vin) As Long
__________________________________________________ _____________________ "AshMorK" wrote in message ... The following function returns a text..but i want to get it as a number: Public Function Gmid(vin) If Mid(vin, 12, 1) < "A" And Mid(vin, 12, 1) 0 Then ID = Right(vin, 6) Else ID = Right(vin, 5) End If Gmid = ID End Function Thanks in advance x your help! AhsMorK (chile) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting a text word or text string to a number | Excel Discussion (Misc queries) | |||
| Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
| Extract number from text/number string.. | Excel Discussion (Misc queries) | |||
| Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
| How do I look up a number within a string of text | Excel Worksheet Functions | |||
Hybrid Mode
