Val will search until it hits a space. Try both of these VB Code: MsgBox Val("21 Days") MsgBox Val("day 21")
MsgBox Val("21 Days") MsgBox Val("day 21")
Forum Rules
Reply With Quote