Dim sVal as string

sVal = Right("ABC",1)

sVal = Format(123, "0.00")


as examples

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Leung" wrote in message
...
Hi

Anyone how i can use the "right" function and "format" function in Excel97
VBA coding?

thanks

Leung