| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wath means
Hi everybody,
In a pice of code I found this expression. Case Is < 2000000000000# Wath means an what is the function of "#" Regards, -- Luis Fernando Ortiz Maldonado |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Wath means
# indicates the number is single precision, not an integer.
"Luis Fernando Ortiz M." wrote: Hi everybody, In a pice of code I found this expression. Case Is < 2000000000000# Wath means an what is the function of "#" Regards, -- Luis Fernando Ortiz Maldonado |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Wath means
You sure it doesn't mean double?
Joel wrote: # indicates the number is single precision, not an integer. "Luis Fernando Ortiz M." wrote: Hi everybody, In a pice of code I found this expression. Case Is < 2000000000000# Wath means an what is the function of "#" Regards, -- Luis Fernando Ortiz Maldonado -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Wath means
Dave: I'm not sure. This is what I did this afternoon.
Dim abc As Single abc = 5.0 Excel changed the 5.0 to 5#. "Dave Peterson" wrote: You sure it doesn't mean double? Joel wrote: # indicates the number is single precision, not an integer. "Luis Fernando Ortiz M." wrote: Hi everybody, In a pice of code I found this expression. Case Is < 2000000000000# Wath means an what is the function of "#" Regards, -- Luis Fernando Ortiz Maldonado -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Wath means
Seach VBA's help for DataType.
Look at Double (and single). You'll see that each help ends with a statement like: The type-declaration character for Double is the number sign (#). and The type-declaration character for Single is the exclamation point (!). I think you just got some help from the VBE since you typed in the decimal point and 0. ======= From the VBE's immediate window: ?typename(5#) Double ?typename(5.0#) Double ?typename(5.0) Double ?typename(5) Integer Joel wrote: Dave: I'm not sure. This is what I did this afternoon. Dim abc As Single abc = 5.0 Excel changed the 5.0 to 5#. "Dave Peterson" wrote: You sure it doesn't mean double? Joel wrote: # indicates the number is single precision, not an integer. "Luis Fernando Ortiz M." wrote: Hi everybody, In a pice of code I found this expression. Case Is < 2000000000000# Wath means an what is the function of "#" Regards, -- Luis Fernando Ortiz Maldonado -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| x means Y | Excel Discussion (Misc queries) | |||
| what is this formula means =+$R$16 | Excel Worksheet Functions | |||
| What exactly {=TRANSPOSE()} means | Excel Worksheet Functions | |||
| hi i would like to know what this means } | New Users to Excel | |||
| Can someone tell me what this means? | Excel Programming | |||
![Luis Fernando Ortiz M.[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
