Data type to hold decimals
 

i have variable x which can hold longs

what type do i need to hold a number which may be greater than 65536 but
also have two decimal places?

is there a similar type conversion for this type similarly as
=cint(...)
and
=clng(....)

Probably an easy q but dont know
thanks
james

Data type to hold decimals
 

Hi James,

i have variable x which can hold longs

what type do i need to hold a number which may be greater than 65536 but
also have two decimal places?

Look at Double Data Type and Single Data Type in VBA help.

is there a similar type conversion for this type similarly as
=cint(...)
and
=clng(....)

Look for CDbl and CSgl in the VBA help page: 'Type Conversion Functions'



---
Regards,
Norman



"James Cornthwaite" wrote in message
...
i have variable x which can hold longs

what type do i need to hold a number which may be greater than 65536 but
also have two decimal places?

is there a similar type conversion for this type similarly as
=cint(...)
and
=clng(....)

Probably an easy q but dont know
thanks
james

Data type to hold decimals
 

thanks very much

"Norman Jones" wrote in message
...
Hi James,

i have variable x which can hold longs

what type do i need to hold a number which may be greater than 65536 but
also have two decimal places?

Look at Double Data Type and Single Data Type in VBA help.

is there a similar type conversion for this type similarly as
=cint(...)
and
=clng(....)

Look for CDbl and CSgl in the VBA help page: 'Type Conversion Functions'



---
Regards,
Norman



"James Cornthwaite" wrote in message
...
i have variable x which can hold longs

what type do i need to hold a number which may be greater than 65536 but
also have two decimal places?

is there a similar type conversion for this type similarly as
=cint(...)
and
=clng(....)

Probably an easy q but dont know
thanks
james