And VBA has its own strconv function, too.

You can read VBAs help for more info.

geebee wrote:

hi,

i have the following:

dim test as string
test = proper(sheets("sheet1").range("A1").value)

but this is not working... i am just trying to assign the Proper(A1) as a
string.

please help

thanks in advance,
geebee

--

Dave Peterson