mas paulus, saya sih kurang mahir pake formula, senangnya pake macro ..... itupun masih coba-coba, pake macro kok coba-coba (democrazy) .......... he he
apakah sudah coba formula ini =DATE(YEAR(A2),MONTH(A2),DAY(A2)) kalau mau dapat value-nya yang nggak pake time, silahkan copy cell yang berisi formula lalu past special (value) -- Thank you and regards, Safri http://www.tebetbarat.com/artikel/safri.htm about me http://www.tb512.com my virtual home http://www.tebetbarat.com Tebet Business Directory consists of addresses and phone numbers of favorite restaurants, traditional markets, hotels, offices, schools, super markets, malls, automotive, gardens, flowers, cakes, advertising, computers, salons, barber shops, cosmetics, banks, apartments etc. Originally it was compiled for personal purposes and then published to the internet as a gateway to search business directory and websites in Tebet and surrounding area. 2008/12/22 Paulus Yokie Radnan K. <[email protected]> > Dear Xl-mania, > > saya baru joint nih, cukup terbantu dengan adanya forum ini, saya ada > pertanyaan mengenai data terlampir, mau menghilangkan format jam yang > menempel di format tanggal, sudah coba pake function "left" tapi kagak bisa. > mohon maaf kl pertanyaan ini pernah dibahas sebelumnya. > > > > terima kasih.... > >
