Results 1 to 7 of 7

Thread: Excel -

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Apr:2010
    Location: Sofia
    Posts: 2

    Excel -

    Excel ... : - . 9010152867. B :15 1990.( )
    , 5 ...
    .

  2. #2
    Registered User
    Join Date: Nov:2006
    Location: BG
    Posts: 530
    6 3 3 -
    , , .
    - Excel- left() right()
    . - right(left(a1,6),2)
    / - 1 "text" /
    . .
    , date(yy,mm,dd) .
    !

  3. #3
    Registered User
    Join Date: Apr:2010
    Location: Sofia
    Posts: 2
    , Format Cells Date. :
    =DATE(IF(INT(MID(A1;3;2))<20;MID(A1;1;2) +1900;IF(INT(MID(A1;3;2))<40;MID(A1;1;2) +1800;MID(A1;1;2)+2000));IF(INT(MID(A1;3 ;2))<20;MID(A1;3;2);IF(INT(MID(A1;3;2))< 40;MID(A1;3;2)-20;MID(A1;3;2)-40));MID(A1;5;2))
    , ... ., .

    ---------- 17:13 ---------- 16:54 ----------

    , : =DATE(MID(A1,1,2),MID(A1,3,2),MID(A1,5,2 ))

  4. #4
    Registered User ined's Avatar
    Join Date: Nov:2006
    Location: Varna
    Posts: 1,078
    EXCEL 1900, 1900 #VALUE!. 19 20 , EXCEL- , '0544112222 4/11/2005, 8/11/1908.

    Quote Originally Posted by knobel View Post
    30, 1900+, 2000+
    +40 2000+, .
    Last edited by ined; 11th April 2010 at 20:53.
    ASRock B85 Pro4, Pentium G3240, DD3 8GB/1333MHz, 120GB SSD + 1TB + 640GB HDD
    Gigabyte GV-R657OC-1GI, CM B500, ASUS 24B1S1, LCD SAMSUNG SM931BW, 173

  5. #5
    Modderhead
    Join Date: Nov:2005
    Location:
    Posts: 4,469
    30, 1900+, 2000+

  6. #6
    Registered User
    Join Date: Aug:2009
    Location:
    Posts: 265
    1900 :
    Code:
    =DATE(1900+LEFT(A1;2)+INT(MID(A1;3;2)/40)*100;MOD(MID(A1;3;2);40);MID(A1;5;2))
    - ined. - , , 'A1' 'TEXT(A1;REPT("0";10))', :
    Code:
    =DATE(1900+A1/10^8+INT(MOD(A1;10^8)/4/10^7)*100;MOD(MOD(A1;10^8)/10^6;40);MOD(A1;10^6)/10^4)

  7. #7
    Drinkin' Master todorpavlov's Avatar
    Join Date: Jun:2006
    Location: Batak, Bulgaria
    Posts: 373
    MB: ASRock K7 EZ upgrade | CPU: AMD Athlon XP 2200+ clocked to 2800+ | VC: ATi Radeon 9550 | RAM: 2x A-DATA 256 MB in Dual Channel Mode | HDD: Exelsor 80GB + Seagate 120 GB | TV tuner: PlayTV Pro2 | DVD-RW: NEC 3550 CD-RW: LG 8525B | LanCard: Compaq NC3121 10/100MB |

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 |