Results 1 to 6 of 6
Thread: Excel
Hybrid View
-
14th September 2007 15:20 #1
Excel
VBA, .
, .
, , 20 , 15.
"", 5 .
: 5 .
.. . - ( )
-
14th September 2007 15:33 #2
VBA- - CInt((Right(Range("a1"), 5)))
=VALUE(RIGHT(A1,5)), , , ,
-
14th September 2007 16:44 #3
-
14th September 2007 17:13 #4
, 2 left i right; value.
, =VALUE(RIGHT(B12,5)) .
, , .
- 2 - 20 , 5 0, 5 .Last edited by thedivaka; 14th September 2007 at 17:24.
-
14th September 2007 17:32 #5
Range("a1") , .. range("kolona red"), -
a="11111111111111111111"
n=cint(right(a,5)) n=11111
- :
D1,D2 ..
-
e1 - =value(right(d1,5))
e2 - =value(right(d2,5)) ..
....
., , , ,
-
14th September 2007 17:54 #6
Me , .
"=value(right(d1,5))" , d1 .
, , - . General Number - , d1 6-, .
:
- - "," ";" .
!
Last edited by srg; 14th September 2007 at 18:01.
. . - ( )




Reply With Quote

Lenovo ThinkPad 15 IdeaPad 15
5th May 2023, 22:16 in