Coba ini mas :
=$B4&" Bagian "&$C4&" tanggal lahir 
"&"0"&DAY($D4)&"/"&"0"&MONTH($D4)&"/"&YEAR($D4)
Ditulis di cell H4.
 
Salam,
 
2008 YEAR OF TRANSFORMATION
TRAC  OPERATION 1  I  TRANSPORTATION MANAGEMENT SYSTEM 
Ahmad Adriansyah I After Sales Department I PT. Serasi Autoraya 
Jl. Demang Lebar Daun No.148 Palembang
Ph. 0711 - 444999 I Mob. 081 - 3737 29 772 I Fax. 0711 - 441188
[EMAIL PROTECTED]
 

________________________________

From: [email protected] on behalf of deny schmeichel
Sent: Tue 2/12/2008 12:52
To: excel
Subject: ]] XL-mania [[ penggabungan data pada tanggal lahir



Please bantuannya ....
data terlampir.
Tx



_________________________________________________________
 
 I NEver Die
   "ined

________________________________

Never miss a thing. Make Yahoo your homepage. 
<http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs>  

 

<<winmail.dat>>

Kirim email ke