Bisa juga dengan Formula seperti dibawah,

="090507"&REPT("0",LEN(REPT("0",5))-LEN(TEXT(ROW(),"0")))&ROW()

Thanks



  ----- Original Message ----- 
  From: sepriansyah encep 
  To: [email protected] 
  Sent: Friday, May 08, 2009 10:23 AM
  Subject: Bls: [belajar-excel] Format Text yang berubah





        Siang juga,

        Coba dgn Formula ini

        =CONCATENATE(A1,"0000")+TEXT(ROW(),"0000")

        thx


        --- Pada Kam, 7/5/09, Purnomo, Bambang <[email protected]> 
menulis:


          Dari: Purnomo, Bambang <[email protected]>
          Topik: [belajar-excel] Format Text yang berubah
          Kepada: [email protected]
          Tanggal: Kamis, 7 Mei, 2009, 2:45 PM


          Selamat siang semuany,
          Mohon bantuanya, gimana ya buat data Text yang di belakangnya di 
tambah angka 00001, dari huruf 090507 menjadi 09050700001, dan kemudia angka 
satunya berubah jadi 2 dan seterusanya
          Trimakasih sebelumnya
          File terlampir 




------------------------------------------------------------------------------
  Yahoo! sekarang memiliki alamat Email baru 
  Dapatkan nama yang selalu Anda inginkan di domain baru @ymail dan 
@rocketmail. br> Cepat sebelum diambil orang lain!

  

  DISCLAIMER
  ---------------
  "This email and any files transmitted with it are private and confidential 
and intended solely for the use of the individual or entity to which they are 
addressed. If you have received this email in error please notify the system 
manager. If you are not an intended recipient, you are hereby notified that any 
disclosure, copying, or distribution of this email, and/or taking any action 
based on its content, is strictly prohibited, and you should: (i) immediately 
delete this email and its attachments from your system, and (ii) inform the 
sender by reply email that you are not an intended recipient. Please note that 
any views or opinions presented in this email are solely those of the 
author/sender and do not necessarily represent those of ANJ Agri Group. ANJ 
Agri Group does not accept (i) any liability for its employee's communications 
that are against ANJ Agri's core values and/or outside the scope of employment 
and (ii) any damage caused by any virus transmitted by this email. Details can 
be found at: http://www.anjagri.com/disclaimer.htm"; 

DISCLAIMER<br />

---------------<br />

"This email and any files transmitted with it are private and

confidential and intended solely for the use of the individual or entity

to which they are addressed. If you have received this email in error

please notify the system manager. If you are not an intended recipient,

you are hereby notified that any disclosure, copying, or distribution of

this email, and/or taking any action based on its content, is strictly

prohibited, and you should: (i) immediately delete this email and its

attachments from your system, and (ii) inform the sender by reply email

that you are not an intended recipient. Please note that any views or

opinions presented in this email are solely those of the author/sender

and do not necessarily represent those of ANJ Agri Group. ANJ Agri Group

does not accept (i) any liability for its employee's communications

that are against ANJ Agri's core values and/or outside the scope of

employment and (ii) any damage caused by any virus transmitted by this

email. Details can be found at: http://www.anjagri.com/disclaimer.htm";

Kirim email ke