Hai Adit;
coba begini: =Text(A5,"0000") atau tanpa formula: Block kolom kode cabang, tekan tombol Ctrl+1 (Format cell) Pilih Custom, lalu ketikkan 0000 Wassalam ~ Bagus ~ ----- Original Message ----- From: Aditya Alvianto [email protected] [XL-mania] To: [email protected] Sent: Tuesday, June 03, 2014 10:30 AM Subject: ]] XL-mania [[ Merubah Kode cabang menjadi 4 digit [1 Attachment] Dear Para Suhu semua, Ane punya pertanyaan spt file terlampir niy. Mohon Pencerahannya..Terima Kasih Best Regards, Aditya Alvianto
