[belajar-excel] Gabung angka tdk ada titik kog ilang

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] Gabung angka tdk ada titik kog ilang

Ferdinan Imers
master semua mohon bantuan kasus sy plis gabung sel tapi titik pada angka
ilang
trims seblmnya

contoh.xlsx (13K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

RE: [belajar-excel] Gabung angka tdk ada titik kog ilang

Heru Safrudin
Silakan disesuaikan format, sesuai selera

 

 <ymsgr:sendIM?heru.safrudin>  

 

 

 

 

 


 <http://www.carajawab.com/?id=heru.safrudin>

 

  _____  

From: [hidden email] [mailto:[hidden email]]
On Behalf Of Ferdinan Imers
Sent: 05 September 2013 09:44
To: [hidden email]
Subject: [belajar-excel] Gabung angka tdk ada titik kog ilang

 

 

master semua mohon bantuan kasus sy plis gabung sel tapi titik pada angka
ilang

trims seblmnya




image001.gif (64K) Download Attachment
image002.png (3K) Download Attachment
image003.gif (1K) Download Attachment
Re-Contoh.xlsx (13K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Gabung angka tdk ada titik kog ilang

Bagus
In reply to this post by Ferdinan Imers
Coba ini pak;
=CONCATENATE("Pembayaran untuk pengadaan ....dengan kontrak ","Rp. ",TEXT(B3,"#,##0"),",-")


Wassalam

~ Bagus ~


  ----- Original Message -----
  From: Ferdinan Imers
  To: [hidden email]
  Sent: Thursday, September 05, 2013 9:43 AM
  Subject: [belajar-excel] Gabung angka tdk ada titik kog ilang


   

  master semua mohon bantuan kasus sy plis gabung sel tapi titik pada angka ilang
  trims seblmnya

 
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Gabung angka tdk ada titik kog ilang

Ferdinan Imers
Trims Pak Heru dan Pak BAgus. sip sudah


2013/9/5 Bagus <[hidden email]>

> **
>
>
> **
> Coba ini pak;
> =CONCATENATE("Pembayaran untuk pengadaan ....dengan kontrak ","Rp.
> ",TEXT(B3,"#,##0"),",-")
>
>
> Wassalam
>
> ~ Bagus ~
>
>
>
> ----- Original Message -----
> *From:* Ferdinan Imers <[hidden email]>
> *To:* [hidden email]
> *Sent:* Thursday, September 05, 2013 9:43 AM
> *Subject:* [belajar-excel] Gabung angka tdk ada titik kog ilang
>
>
>
> master semua mohon bantuan kasus sy plis gabung sel tapi titik pada angka
> ilang
> trims seblmnya
>
>  
>