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"