Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
What a shame
My problem is I have numx as Textbox and then this: If Sgn(num1) = -1 Or Sgn(num2) = -1 then dosnt work so only way for me is: num1_new = CLng(num1) num2_new = CLng(num2) If Sgn(num1_new) = -1 Or Sgn(num2_new) = -1 then is that? "Frank Kabel" píse v diskusním príspevku ... Hi AFAIK it is not possible to change the variable's data type during runtime Frank TJF wrote: Looks like I have problem with data declarations. Do you know how can I change data declaration? I know this new = CDbl(old) but I need something like this: old = CDbl(old) ...but this of course dosnt work is there something like this old = set as double |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I subtract a negative number from a positive number? | Excel Discussion (Misc queries) | |||
Change positive number to negative number | Excel Worksheet Functions | |||
Converting Negative Number to Postive number | Excel Worksheet Functions | |||
Converting a negative number to a positive number | Excel Discussion (Misc queries) | |||
2003= negative number&2004= negative number How Do I Calculate gro | Excel Worksheet Functions |