Hai Emi; Coba begini: =DATE(MID(A2,2,4),MID(A2,7,2),MID(A2,10,2))
sesuaikan format cellnya copas kebawah Wassalam ~ Bagus ~ ----- Original Message ----- From: Emi [email protected] [belajar-excel] To: [email protected] Sent: Friday, May 23, 2014 11:06 AM Subject: [***SPAM*** Score/Req: 05.10/5.0] [belajar-excel] Menukar Text kepada format tanggal [1 Attachment] Dear Teman BeExcel Saya sudah coba rumus untuk menukar text kepada format date, tapi masih ada error Rumusnya ialah =DATE(LEFT(A2,4),MID(A2,6,2),MID(A2,11,2)) Mungkin karena ada spasi, gimana caranya. Mohon bantuan teman2. Terima kasih. -Emi Data Asli Date Format Yang diinginkan 2014-03-18 #VALUE! 18 Mar 2014 2014-03-19 #VALUE! 19 Mar 2014 2014-03-19 #VALUE! 19 Mar 2014 2014-03-19 #VALUE! 19 Mar 2014 2014-03-19 #VALUE! 19 Mar 2014 2014-03-19 #VALUE! 19 Mar 2014 2014-03-19 #VALUE! 19 Mar 2014 2014-03-19 #VALUE! 19 Mar 2014 2014-03-20 #VALUE! 20 Mar 2014
