Results 1 to 7 of 7
Thread: Excel -
Hybrid View
-
11th April 2010 18:22 #1Registered User
Join Date: Apr:2010
Location: Sofia
Posts: 2
Excel -
Excel ... : - . 9010152867. B :15 1990.( )
, 5 ...
.
-
11th April 2010 18:45 #2Registered 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) .
!
-
11th April 2010 19:13 #3Registered 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 ))
-
11th April 2010 20:42 #4
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
-
11th April 2010 20:44 #5Modderhead
Join Date: Nov:2005
Location:
Posts: 4,469
30, 1900+, 2000+
-
12th April 2010 10:28 #6Registered User
Join Date: Aug:2009
Location:
Posts: 265
1900 :
- ined. - , , 'A1' 'TEXT(A1;REPT("0";10))', :Code:=DATE(1900+LEFT(A1;2)+INT(MID(A1;3;2)/40)*100;MOD(MID(A1;3;2);40);MID(A1;5;2))
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)
-
12th April 2010 10:44 #7MB: 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 |




Reply With Quote

7th May 2023, 16:02 in PC