admin howto-123.com on March 9, 2017
  • Tekan SHIFT+F9 pada field tanggal,
  • Tambahkan pada field tersebut data: \@”dd MMMM yyyy” into the merge file of date. And the merge field of date should like this: {MERGEFIELD DATE\@ “MMMM d, yyy”}

 

Please add the following formatting data \# $,0.00 into the merge file of currency, and the merge field of currency should look like this:

{MERGEFIELD CURRENCY\# $,0.00}

change-foramt-2

Note:the ‘\# $,0.00’ in the field is referred to as a numeric picture switch. Other possibilities include:

(1). \# 0 for rounded whole numbers

(2). \# ,0 for rounded whole numbers with a thousand separator

(3). \# ,0.00 for numbers accurate to two decimal places, with a thousand separator

(4). \# $,0 for rounded whole dollar with a thousand separator

(5). \# “$,0.00;($,0.00);’-‘” for currency, with brackets around negative numbers and a hyphen for 0 values

Besides, sometimes the number may be percentage, you may need to edit the field{ «Percent» } so that you get {=«Percent»*100 \# 0.00%}.

admin howto-123.com on February 20, 2017

JIKA Fungsi seperti MATCH, VLOOKUP dan HLOOKUP tidak berfungsi, harus mencocokkan tipe data (nomor atau teks) sedangkan COUNTIF / SUMIF tidak membeda. Apakah Anda menggunakan MATCH untuk menemukan posisi atau hanya untuk menentukan apakah nilai ada di data Anda?

Jika Anda memiliki nilai lookup numerik Anda dapat mengkonversi ke teks dalam formula dengan menggunakan & “”, misalnya

= MATCH (A1 & “”, B: B, 0)

Jimmy Bharata on September 4, 2016

Pertanyaan bagaimana merubah blogspot.co.id menjadi blogspot.com? Terjanya jawabannya sangat mudah

Sisipkan kode di bawah tag HTML <head>berikut ini agar website blogspot Anda mengarah ke blogspot.com
<script type=’text/javascript’> var str= window.location.href.toString(); if ((str.indexOf(‘.com/’))==’-1′) { var str1=str.substring(str.lastIndexOf(“.blogspot.”)); if (str1.indexOf(‘/’)==’-1′) { var str2=str1; } else { var str2=str1.substring(0,str1.indexOf(‘/’)+1); } window.location.href =window.location.href.toString().replace(str2,’.blogspot.com/ncr/’); } </script>

Selamat bereksplorasi dan mencoba ya..