Lyuciena

0 0

?

 - e-mail

 
.

 -

, , ,
   Lyuciena

 -

( : 3) __
( : 1) _

 -

 LiveInternet.ru:
: 21.05.2004
: 68
: 30
: 151
:

Excel-

, 20 2007 . 22:53 () +

- ..
2. Excel 97 , Visual Basic - .
:
Excel. : -- Visual Basic.
: -.
1 .
( ) , - . , .

3. , , . : Microsoft Excel. () .
4. Excel.
5. Excel - - , , , .
6. , , D1, : 789 456 321,85.
, .
, , . , SorceDigits D1, , , . , !
:
1. . .
2. , , . . . .
3. , , . . ( , , ).
4. - .
5. .
6. , , . . . , (, , ).
.



: [1] []
Lyuciena   0 0 , 20 2007 . 22:55 ()
Function (SourceDigits As Currency) As String
Dim STRNG As String, CHAR, Result As String, Prom As String
Dim I, STRNG_len As Long
Dim SourceDigTail As Currency

SourceDigTail = (SourceDigits Int (SourceDigits)) * 100
SourceDigits = Int (SourceDigits)

STRNG = SourceDigits
STRNG_len = Len (STRNG)
For i = 1 To 9 - STRNG_len Step 1
STRNG = 0 & STRNG
Next i

For i = 9 To 9 - STRNG_len + 1 Step -1
CHAR = Mid (STRNG, i, 1)
If CHAR = Then GoTo end_c

If i = 2 Or i = 5 Or i = 8 Then
IF CHAR = 1 Then
CHAR = Mid (STRNG, i, 2)
Select Case CHAR
Case 10
Prom =
Case 11
Prom =
Case 12
Prom =
Case 13
Prom =
Case 14
Prom =
Case 15
Prom =
Case 16
Prom =
Case 17
Prom =
Case 18
Prom =
Case 19
Prom =
End Select
Else If char Not = 1
Select Case CHAR
Case 0
Prom =
Case 2
Prom =
Case 3
Prom =
Case 4
Prom =
Case 5
Prom =
Case 6
Prom =
Case 7
Prom =
Case 8
Prom =
Case 9
Prom =
End Select
End If
End If
If i = 1 Or i = 4 Or i = 7 Then
Select Case CHAR
Case 0
Prom =
Case 1
Prom =
Case 2
Prom =
Case 3
Prom =
Case 4
Prom =
Case 5
Prom =
Case 6
Prom =
Case 7
Prom =
Case 9
Prom =
End Select
End If
If i = 3 Or i = 6 Or i = 9 Then

If i = 9 And Mid (STRNG, i - 1, 1) = 1 Then
Result = & Result
GoTo end_c
End If



If i = 3 And Mid (STRNG, i - 1, 1) = 1 Then
Result = & Result
GoTo end_c
End If



If i = 6 And Mid (STRNG, i - 1, 1) = 1 Then
Result = & Result
GoTo end_c
End If

Select Case CHAR
Case 0
Prom =
Case 1
If i = 6 Then
Prom =
Else
Prom =

End If
Case 2

If i = 6 Then
Prom =
Else
Prom =
End If
Case 3
Prom =

Case 4
Prom =
Case 5
Prom =
Case 6
Prom =
Case 7
Prom =
Case 8
Prom =
Case 9
Prom =
End Select
End If
Select Case i

Case 3
Select Case CHAR
Case 1
Result = & Result
Case 2 , 3, 4
Result = & Result
Case 5, 6, 7, 8 , 9
Result = & Result
Case 0
If STRNG_len > 6 Then
Result = & Result
End If
End Select


Case 6
Select Case CHAR
Case 1
Result = & Result
Case 2, 3, 4
Result = & Result
Case 5, 6, 7, 8 , 9
Result = & Result
Case 0
If STRNG_len > 3 Then
Result = & Result
End If
End Select

Case 9
Select Case CHAR
Case 1
Result = & Result
Case 2 , 3, 4
Result = & Result
Case 0, 5, 6, 7 , 8 , 9
Result = & Result
End Select
End Select

Result = Prom & Result

end_c:
Next i

Result = Format(Mid(Result, 1, 1), > ) & Mid (Result, 2)

= Result & Format (SourceDigTail, 00) & .

End Function
   
   , 04 2008 . 22:51 ()
. . "". .


slabada@tut.by
        |    
Lyuciena   0 0 , 05 2008 . 22:22 ()
! , . , .
))
   
   , 29 2009 . 17:42 ()


.
        |    
   , 11 2009 . 14:24 ()
(1000000) " 00 ."

:

Case "0"
If STRNG_len > 3 Then
Result = " " & Result
End If

:


Case "0"
If STRNG_len > 3 And Left(Right(STRNG, 6), 3) <> "000" Then
Result = " " & Result
End If

"" .

:

Application.Volatile

- Excel :)

- ! .

,
, -
        |    
Lyuciena   0 0 , 17 2009 . 00:55 ()
, )
- ... - - ...
   
   , 25 2009 . 12:45 ()
,

, .... ?
        |    
   , 19 2010 . 18:42 ()
: SyntaxError : SourceDigTail = (SourceDigits Int (SourceDigits)) * 100
        |    
Lyuciena   0 0 , 25 2010 . 22:30 ()
- , . - , , .

- - .
   

: [1] []
 

:
: 

: ( )

:

  URL