Results 1 to 6 of 6
Thread: Excel
Hybrid View
-
8th February 2005 15:21 #1
Excel
- 1000+ -. - - 4.
- , !
- , .
, ., .
-
8th February 2005 16:34 #2
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 .
-
8th February 2005 16:52 #3
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...
* , ... , .
-
8th February 2005 17:41 #4
, :
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...
* , ... , .
-
8th February 2005 16:44 #5- . 1 . - .
Originally Posted by bat_zerga
-
8th February 2005 16:50 #6




Reply With Quote

R9 280,
7th May 2023, 21:28 in