Oh iya formulanya akan mengalami sedikit perubahan menjadi :
=A5&REPT(" ";10)&B5&REPT(" ";10)&TEXT(C5;"000")
Ambil dari formula Mr HK.
Salam,
DD
From: Dede [email protected] [belajar-excel]
[mailto:[email protected]]
Sent: 22 April 2015 11:38
To: [email protected]
Subject: RE: [belajar-excel] Menampilkan Angka Nol dan CopyPaste ke Notepad
Ikutan yah...
Mungkin untuk pertanyaan pertama bisa dicoba dengan cara :
Block range cell C5:C7 à Format Cells à Custom à Type isi dengan #.000
Semoga sesuai harapan.
Salam,
DD
From: hendrik karnadi [email protected] [belajar-excel]
[mailto:[email protected]]
Sent: 22 April 2015 10:51
To: [email protected]
Subject: Re: [belajar-excel] Menampilkan Angka Nol dan CopyPaste ke Notepad
Hai Seismica,
Jawaban atas pertanyaan pertama... kayaknya ga bisa.
Jawaban atas pertanyaan kedua:
=A5&REPT(" ",10)&B5&REPT(" ",10)&C5
Salam,
HK
_____
From: "Zerlinda Seismica [email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Wednesday, 22 April 2015, 9:17
Subject: [belajar-excel] Menampilkan Angka Nol dan CopyPaste ke Notepad [1
Attachment]
Assalamualaikum wrwb
Sebelumnya terima kasih buat Mas Kid dan Mas Hendrik atas solusi
kemrin...semoga tidak bosen lagi untuk memberi pencerahan...
Problemnya adalah menampilkan angka nol didepan angka asli..solusi saya pake
tanda kutip tapi jadi text padahal saya ingin number.
Yang kedua data dari excel dicopy paste ke notepad/textpad tp harus ada spasi
tertentu..untuk detailnya saya kirimkan kadonya...
ITu aja...semoga tetep diberi semangat....
Wassalam wrwb
Seismica
_____
This e-mail and any files transmitted with it are confidential and intended
solely for the use of the individual to whom it is addressed. If you have
received this email in error please send it back to the person that sent it to
you. Any views or opinions presented are solely those of its author and do not
necessarily represent those of NABATI or any of its subsidiary companies.
Unauthorized publication, use, dissemination, forwarding, printing or copying
of this email and its associated attachments is strictly prohibited.
