Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Convert Variant to Number

Status
Not open for further replies.

SDS100UK

MIS
Jul 15, 2001
185
GB
Hi,

I would like to know how to convert the output of a function which is variant to a number.

Any ideas? I am sure it can be done but I have no idea how.

Many thanks


Steven
 
Look at Type Conversion Functions in the help.

You might find what you are looking for in there.

CBool(expression)
CByte(expression)
CCur(expression)
CDate(expression)
CDbl(expression)
CDec(expression)
CInt(expression)
CLng(expression)
CSng(expression)
CVar(expression)
CStr(expression)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top