Coba pake formula: =A1&" "&TEXT(B1,"DD/MM/YY")
From: [email protected] [mailto:[email protected]] Sent: Monday, October 12, 2015 4:59 PM To: [email protected] Subject: [belajar-excel] ask: gabung data teks dgn tanggal, kenapa gagal terus ya??? [help dunk] [1 Attachment] para master sy minta tulung dung, udah coba rumus buat gabungin data teks dgn tanggal tapi kok gagal terus ya? format cellnya selalu muncul angka padahal rumusnya udah sy cek dan sama sekali ga ada yg beda dgn contoh rumusnya (di sheet 2) (file terlampir) mohon bantuannya master, tks bgt ya
