| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I can't figure out how to hold chart references firm when inserting data | Excel Discussion (Misc queries) | |||
| Hold conditional formatting when sorting filtered data | Excel Discussion (Misc queries) | |||
| How much data can Excel hold. | Excel Discussion (Misc queries) | |||
| Multiple Userform Hold Data to edit | Excel Programming | |||
| insert to hold data | Excel Programming | |||
Hybrid Mode
