| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
val a string
Hi,
z3 = (Mid(z, (InStr(1, z, "(") + 1), Len(z) - (InStr(1, z, "(") + 1))) creates a string, which is 1.96% I want to value it so I changed the formula to z3 = val((Mid(z, (InStr(1, z, "(") + 1), Len(z) - (InStr(1, z, "(") + 1)))) but it does not work Any ideas? Thanks, David |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Grabbing string values from the end of a string of an unknown length | Excel Programming | |||
| Replace Hyperlink Addresses Help 'Dim OldStr As String, NewStr As String | Excel Programming | |||
| Importing Long String - String Manipulation (INVRPT) (EDI EANCOM 96a) | Excel Programming | |||
| Importing Long String - String Manipulation (EDI EANCOM 96a) | Excel Programming | |||
| Create a formula into a String then assign string to a cell | Excel Programming | |||
Threaded Mode
