Search a cell that contains words and numbers and convert the numbers to metric

macropod · #1 10-07-2014, 01:49 PM

In that case, I have to assume whatever else you have is tripping up over the Evaluate finction. Try replacing each instance of:

StrConv = Evaluate(Replace(Replace(StrConv, "-", "+"), "'", "*12+0"))
with:

Code:

              If InStr(StrConv, "-") > 0 Then
                If InStr(StrConv, "/") > 0 Then
                  StrConv = Split(StrConv, "-")(0) + Split(Split(StrConv, "-")(1), "/")(0) / Split(Split(StrConv, "-")(1), "/")(1)
                Else
                  StrConv = Split(StrConv, "-")(0) + CSng(Split(StrConv, "-")(1))
                End If
              End If

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Words in my document were converted to numbers????	MikeD23	Word	1	08-26-2012 11:09 AM
can word convert numbers?	koolfire	Word	2	01-07-2012 02:12 PM
Convert numbers to a specific text string	francis	Excel	1	10-06-2011 01:43 PM
Numbers in Words	janak	Excel	2	12-19-2010 08:53 PM
Numbers Convert in word in MS Access	towhid	Office	0	08-19-2010 01:17 AM