Results 1 to 6 of 6

Thread: Excel

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User srg's Avatar
    Join Date: Oct:2003
    Location: .
    Posts: 2,025

    Excel

    VBA, .

    , .
    , , 20 , 15.

    "", 5 .

    : 5 .

    .
    . . - ( )

  2. #2
    's Avatar
    Join Date: Mar:2005
    Location:
    Posts: 379
    VBA- - CInt((Right(Range("a1"), 5)))

    =VALUE(RIGHT(A1,5))
    , , , ,

  3. #3
    Registered User srg's Avatar
    Join Date: Oct:2003
    Location: .
    Posts: 2,025
    Quote Originally Posted by View Post
    VBA- - CInt((Right(Range("a1"), 5)))

    =VALUE(RIGHT(A1,5))
    , .

    - 1
    VBA- : Expected:Identifier

    , CInt - Value Integer, Value, String.
    . . - ( )

  4. #4
    .... thedivaka's Avatar
    Join Date: Mar:2006
    Location: 8.3
    Posts: 4,951
    , 2 left i right; value.

    , =VALUE(RIGHT(B12,5)) .
    , , .

    - 2 - 20 , 5 0, 5 .
    Last edited by thedivaka; 14th September 2007 at 17:24.

  5. #5
    's Avatar
    Join Date: Mar:2005
    Location:
    Posts: 379
    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)) ..
    ....

    .
    , , , ,

  6. #6
    Registered User srg's Avatar
    Join Date: Oct:2003
    Location: .
    Posts: 2,025
    Me , .
    "=value(right(d1,5))" , d1 .

    , , - . General Number - , d1 6-, .

    :
    - - "," ";" .

    !
    Last edited by srg; 14th September 2007 at 18:01.
    . . - ( )

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |