coba pada cell B2 dibuat formula seperti ini : =Text(B1,"[$-421]dddd")
atau pada cell B2 atur format cellnya dengan Number category custom, dan type [$-421]dddd semoga membantu.. > Para Exceller, > > Cell B2 berisi "=B1" dimana B1 berisi suatu tanggal > Jika B1 berisi tanggal hari ini (7 April 2011) > Maka B2 maunya berisi " Kamis" > > Bagaimana membuat Format Cells B2 menjadi hari dengan versi Indonesia? > > Di custom Listsnya sudah saya tambahkan Minggu, Senin dst > Masih nggak bisa (nggak tahu format cells Customnya bagaimana) > > Nggak perlu lampiran ya.. > Masih trauma lampiran tidak bisa mbuka.... > > > Wassalam > Agung W > > ____________ _________ _________ _________ _________ _________ _________ Notice : This e-mail (and any attachment) is strictly confidential and is intended only for the addressee(s)above. Is strictly prohibited to forward, print, copy, or otherwise reproduce this message that would allow it to be viewed by any individual not originally listed as a recipient(s). If you have received this e-mail in error, please immediately notify the sender and delete this message. The opinions expressed in this e-mail (and any attachment) are those of the individual sender and may not necessarily reflect the views of PT Pusri. ____________ _________ _________ _________ _________ _________ _________
