Re: Data type to hold decimals

thanks very much

"Norman Jones" <normanjones@xxxxxxxxxxxxxxxxxxx> wrote in message
news:eOgHbRykGHA.2200@xxxxxxxxxxxxxxxxxxxxxxx
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" <jamescornthwaite@xxxxxxxxxxxxxx> wrote in message
news:itqdnbzZ_b30UQjZnZ2dnUVZ8tKdnZ2d@xxxxxxxxx
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





.

Relevant Pages

  • Re: P&L report must give diff. figures for Jan then for other months, how to do?
    ... Therefore the implicit data type conversion ... from member object to scalar is applied (I hope to write an article ... Deepak Puri ...
    (microsoft.public.sqlserver.olap)
  • Re: Remote View Boolean Fields
    ... This produces an error "Type conversion required by the DataType property ... from SQL Server's Bit data type. ... to convert to foxpro logical. ... required by DataType field is invalid". ...
    (microsoft.public.fox.programmer.exchange)
  • Data type error when trying to compile model
    ... This model can't generate code for the intended TARGET C compiler. ... The Data Type Conversion block that is causing the error specifies the ...
    (comp.soft-sys.matlab)
  • Re: Data type to hold decimals
    ... Look at Double Data Type and Single Data Type in VBA help. ... Look for CDbl and CSgl in the VBA help page: 'Type Conversion Functions' ...
    (microsoft.public.excel.programming)
  • Re: Decimal Arithmetic
    ... James J. Weinkam wrote in message ... ... >>> data type. ... >has a true INTEGER data type, the following is true of any INTEGER expression: ...
    (comp.lang.pl1)