Masih valid untuk angka kurang dari 1 trilyun
Sandy

    On Sunday, September 29, 2019, 08:24:10 AM GMT+7, Cari Kebenaran 
cahayailm...@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

  

Terima kasih atas tanggapannya. Ya, saya ingin pemisah ribuannya jadi titik 
seperti yang dipakai Indonesia. 

On Fri, Sep 27, 2019 at 5:21 PM 'Mr. Kid' mr.nm...@gmail.com [belajar-excel] 
<belajar-excel@yahoogroups.com> wrote:

  

wa'alaikumussalam wr wb
Boleh tahu kenapa diubah jadi bertipe text ? Apakah karena supaya pemisah 
ribuannya jadi titik seperti yang dipakai Indonesia ?





On Fri, Sep 27, 2019 at 4:59 PM Cari Kebenaran cahayailm...@gmail.com 
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:

  

Assalamu'alaikum Wr. Wb.

Para master dan anggota milis yang saya hormati. Tolong dibantu untuk keperluan 
saya. 
Saya ingin mengubah nilai angka pada suatu range yang dihasilkan dari rumus 
menjadi berformat text  tanpa menghilangkan tanda titik (.) sebagai separator 
ribuannya. Selengkapnya silakan lihat lampiran. 
Atas perhatian dan bantuannya saya ucapkan terima kasih 







  #yiv6289568488 #yiv6289568488 -- #yiv6289568488ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6289568488 
#yiv6289568488ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6289568488 
#yiv6289568488ygrp-mkp #yiv6289568488hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv6289568488 #yiv6289568488ygrp-mkp #yiv6289568488ads 
{margin-bottom:10px;}#yiv6289568488 #yiv6289568488ygrp-mkp .yiv6289568488ad 
{padding:0 0;}#yiv6289568488 #yiv6289568488ygrp-mkp .yiv6289568488ad p 
{margin:0;}#yiv6289568488 #yiv6289568488ygrp-mkp .yiv6289568488ad a 
{color:#0000ff;text-decoration:none;}#yiv6289568488 #yiv6289568488ygrp-sponsor 
#yiv6289568488ygrp-lc {font-family:Arial;}#yiv6289568488 
#yiv6289568488ygrp-sponsor #yiv6289568488ygrp-lc #yiv6289568488hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6289568488 
#yiv6289568488ygrp-sponsor #yiv6289568488ygrp-lc .yiv6289568488ad 
{margin-bottom:10px;padding:0 0;}#yiv6289568488 #yiv6289568488actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6289568488 
#yiv6289568488activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6289568488
 #yiv6289568488activity span {font-weight:700;}#yiv6289568488 
#yiv6289568488activity span:first-child 
{text-transform:uppercase;}#yiv6289568488 #yiv6289568488activity span a 
{color:#5085b6;text-decoration:none;}#yiv6289568488 #yiv6289568488activity span 
span {color:#ff7900;}#yiv6289568488 #yiv6289568488activity span 
.yiv6289568488underline {text-decoration:underline;}#yiv6289568488 
.yiv6289568488attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv6289568488 .yiv6289568488attach div a 
{text-decoration:none;}#yiv6289568488 .yiv6289568488attach img 
{border:none;padding-right:5px;}#yiv6289568488 .yiv6289568488attach label 
{display:block;margin-bottom:5px;}#yiv6289568488 .yiv6289568488attach label a 
{text-decoration:none;}#yiv6289568488 blockquote {margin:0 0 0 
4px;}#yiv6289568488 .yiv6289568488bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6289568488 
.yiv6289568488bold a {text-decoration:none;}#yiv6289568488 dd.yiv6289568488last 
p a {font-family:Verdana;font-weight:700;}#yiv6289568488 dd.yiv6289568488last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6289568488 
dd.yiv6289568488last p span.yiv6289568488yshortcuts 
{margin-right:0;}#yiv6289568488 div.yiv6289568488attach-table div div a 
{text-decoration:none;}#yiv6289568488 div.yiv6289568488attach-table 
{width:400px;}#yiv6289568488 div.yiv6289568488file-title a, #yiv6289568488 
div.yiv6289568488file-title a:active, #yiv6289568488 
div.yiv6289568488file-title a:hover, #yiv6289568488 div.yiv6289568488file-title 
a:visited {text-decoration:none;}#yiv6289568488 div.yiv6289568488photo-title a, 
#yiv6289568488 div.yiv6289568488photo-title a:active, #yiv6289568488 
div.yiv6289568488photo-title a:hover, #yiv6289568488 
div.yiv6289568488photo-title a:visited {text-decoration:none;}#yiv6289568488 
div#yiv6289568488ygrp-mlmsg #yiv6289568488ygrp-msg p a 
span...yiv6289568488yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6289568488 
.yiv6289568488green {color:#628c2a;}#yiv6289568488 .yiv6289568488MsoNormal 
{margin:0 0 0 0;}#yiv6289568488 o {font-size:0;}#yiv6289568488 
#yiv6289568488photos div {float:left;width:72px;}#yiv6289568488 
#yiv6289568488photos div div {border:1px solid 
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv6289568488 
#yiv6289568488photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6289568488
 #yiv6289568488reco-category {font-size:77%;}#yiv6289568488 
#yiv6289568488reco-desc {font-size:77%;}#yiv6289568488 .yiv6289568488replbq 
{margin:4px;}#yiv6289568488 #yiv6289568488ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv6289568488 #yiv6289568488ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6289568488 
#yiv6289568488ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6289568488 
#yiv6289568488ygrp-mlmsg select, #yiv6289568488 input, #yiv6289568488 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6289568488 
#yiv6289568488ygrp-mlmsg pre, #yiv6289568488 code {font:115% 
monospace;}#yiv6289568488 #yiv6289568488ygrp-mlmsg * 
{line-height:1.22em;}#yiv6289568488 #yiv6289568488ygrp-mlmsg #yiv6289568488logo 
{padding-bottom:10px;}#yiv6289568488 #yiv6289568488ygrp-msg p a 
{font-family:Verdana;}#yiv6289568488 #yiv6289568488ygrp-msg 
p#yiv6289568488attach-count span {color:#1E66AE;font-weight:700;}#yiv6289568488 
#yiv6289568488ygrp-reco #yiv6289568488reco-head 
{color:#ff7900;font-weight:700;}#yiv6289568488 #yiv6289568488ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv6289568488 #yiv6289568488ygrp-sponsor 
#yiv6289568488ov li a {font-size:130%;text-decoration:none;}#yiv6289568488 
#yiv6289568488ygrp-sponsor #yiv6289568488ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6289568488 
#yiv6289568488ygrp-sponsor #yiv6289568488ov ul {margin:0;padding:0 0 0 
8px;}#yiv6289568488 #yiv6289568488ygrp-text 
{font-family:Georgia;}#yiv6289568488 #yiv6289568488ygrp-text p {margin:0 0 1em 
0;}#yiv6289568488 #yiv6289568488ygrp-text tt {font-size:120%;}#yiv6289568488 
#yiv6289568488ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv6289568488   

Attachment: Mengubah Nilai Angka dari Rumus Menjadi Text.xlsx
Description: MS-Excel 2007 spreadsheet

  • [belajar-excel] M... Cari Kebenaran cahayailm...@gmail.com [belajar-excel]
    • Re: [belajar... 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
      • Re: [bel... Cari Kebenaran cahayailm...@gmail.com [belajar-excel]
        • Re: ... 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
        • Re: ... Sandy sandywars...@yahoo.com [belajar-excel]
      • Re: [bel... Cari Kebenaran cahayailm...@gmail.com [belajar-excel]
        • Re: ... Cari Kebenaran cahayailm...@gmail.com [belajar-excel]
          • ... ghozi alkatiri ghozialkat...@yahoo.co.id [belajar-excel]
            • ... Cari Kebenaran cahayailm...@gmail.com [belajar-excel]
    • Re: [belajar... ghozi alkatiri ghozialkat...@yahoo.co.id [belajar-excel]

Reply via email to