Results 1 to 6 of 6

Thread: Excel

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    stalinator 2047 bat_zerga's Avatar
    Join Date: Oct:2003
    Location: /
    Posts: 4,214

    Excel

    - 1000+ -. - - 4.
    - , !
    - , .
    , ., .

  2. #2
    Registered User Dreamfall's Avatar
    Join Date: Feb:2005
    Location: Sofia
    Posts: 5
    file-a 10000000+ - -> Save As Text (Tab Delimited)!!!! -> file Excel, , text import wizard -> file origin Windows (ANSI) radio-box "fixed width". -> Next, Data preview Excel . 4 .

  3. #3
    ⛧ ⛧ mitku's Avatar
    Join Date: Oct:2003
    Location: Sofia
    Posts: 17,911
    A1 ... , :
    Code:
    =DATE(MID(A1;1;2);MID(A1;3;2);MID(A1;5;2))
    ... ... ... ... , , .. -
    P.S. ()... 2 -, , .
    Last edited by mitku; 8th February 2005 at 17:07.
    * Last Words: Modding... clocking?! Never!... This is bullshit! ... well... maybe only this time... just a little...
    * , ... , .

  4. #4
    ⛧ ⛧ mitku's Avatar
    Join Date: Oct:2003
    Location: Sofia
    Posts: 17,911
    , :
    Code:
    =DATE(IF(DECIMAL(MID(A1;3;2);10)<20;MID(A1;1;2)+1900;IF(DECIMAL(MID(A1;3;2);10)<40;MID(A1;1;2)+1800;MID(A1;1;2)+2000));IF(DECIMAL(MID(A1;3;2);10)<20;MID(A1;3;2);IF(DECIMAL(MID(A1;3;2);10)<40;MID(A1;3;2)-20;MID(A1;3;2)-40));MID(A1;5;2))
    * Last Words: Modding... clocking?! Never!... This is bullshit! ... well... maybe only this time... just a little...
    * , ... , .

  5. #5
    Live at Wembley savaman's Avatar
    Join Date: Jun:2004
    Location:
    Posts: 1,631
    Quote Originally Posted by bat_zerga
    - 1000+ -. - - 4.
    - . 1 . - .

  6. #6
    stalinator 2047 bat_zerga's Avatar
    Join Date: Oct:2003
    Location: /
    Posts: 4,214
    - savaman
    - , !
    - , .
    , ., .

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 |