tetep tidak berhasil mr. :(( Salam
Shenly ^^*
Pada Jumat, 31 Oktober 2014 22:16, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> menulis:
Bagaimana jika dicoba format number di a1 dan a2 adalah general dulu?On
Nov 1, 2014 2:08 AM, "Shenly [email protected] [belajar-excel]"
<[email protected]> wrote:
oooh maaf mr..sudah sya cek bukan karena type yg berbeda.......semua type
karakter adalah angka...sudah sya coba masukan nomor ganjing... -13,500,000 dan
7,000,000 hasilnya plus 6,500,000 harusnya kan minus....memang benar sih hasil
angkanya sesuai...tapi jenisnya itu kenapa bisa terbalik..yang harusnya minus,
ko jadi plus, apa ada kesalahan dengan program excel saya, atau di
konfigurasinya????seperti itu mr Salam
Shenly ^^*
Pada Jumat, 31 Oktober 2014 19:30, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> menulis:
Coba A2 diganti menjadi 2.000.000 dan lihat hasilnya. Jika hasilnya adalah
senilai A2 yang baru, maka cell A1 berisi suatu nilai data yang bertipe TEXT.
Ubah nilai A1 agar menjadi bertipe NUMERIC.
Wassalam,
Kid.
2014-10-31 22:45 GMT+11:00 Shenly [email protected] [belajar-excel]
<[email protected]>:
halo master...mau tanya lagi....ini gimna ya ....ketika saya blok a1 =
-10.000.0000 dan a2 = 5.000.000 harusnya kan hasilnya yg terlihat di pokong
bawah / bar bawah...itu harusnya -5.000.000 , ko ini malah plus 5.000.000apakah
ada yg salah dengan konfigurasi excel saya, atau giman aya ?????
Salam
Shenly ^^*
#yiv7425998110 #yiv7425998110 -- #yiv7425998110ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7425998110
#yiv7425998110ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7425998110
#yiv7425998110ygrp-mkp #yiv7425998110hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7425998110 #yiv7425998110ygrp-mkp #yiv7425998110ads
{margin-bottom:10px;}#yiv7425998110 #yiv7425998110ygrp-mkp .yiv7425998110ad
{padding:0 0;}#yiv7425998110 #yiv7425998110ygrp-mkp .yiv7425998110ad p
{margin:0;}#yiv7425998110 #yiv7425998110ygrp-mkp .yiv7425998110ad a
{color:#0000ff;text-decoration:none;}#yiv7425998110 #yiv7425998110ygrp-sponsor
#yiv7425998110ygrp-lc {font-family:Arial;}#yiv7425998110
#yiv7425998110ygrp-sponsor #yiv7425998110ygrp-lc #yiv7425998110hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7425998110
#yiv7425998110ygrp-sponsor #yiv7425998110ygrp-lc .yiv7425998110ad
{margin-bottom:10px;padding:0 0;}#yiv7425998110 #yiv7425998110actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7425998110
#yiv7425998110activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7425998110
#yiv7425998110activity span {font-weight:700;}#yiv7425998110
#yiv7425998110activity span:first-child
{text-transform:uppercase;}#yiv7425998110 #yiv7425998110activity span a
{color:#5085b6;text-decoration:none;}#yiv7425998110 #yiv7425998110activity span
span {color:#ff7900;}#yiv7425998110 #yiv7425998110activity span
.yiv7425998110underline {text-decoration:underline;}#yiv7425998110
.yiv7425998110attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7425998110 .yiv7425998110attach div a
{text-decoration:none;}#yiv7425998110 .yiv7425998110attach img
{border:none;padding-right:5px;}#yiv7425998110 .yiv7425998110attach label
{display:block;margin-bottom:5px;}#yiv7425998110 .yiv7425998110attach label a
{text-decoration:none;}#yiv7425998110 blockquote {margin:0 0 0
4px;}#yiv7425998110 .yiv7425998110bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7425998110
.yiv7425998110bold a {text-decoration:none;}#yiv7425998110 dd.yiv7425998110last
p a {font-family:Verdana;font-weight:700;}#yiv7425998110 dd.yiv7425998110last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7425998110
dd.yiv7425998110last p span.yiv7425998110yshortcuts
{margin-right:0;}#yiv7425998110 div.yiv7425998110attach-table div div a
{text-decoration:none;}#yiv7425998110 div.yiv7425998110attach-table
{width:400px;}#yiv7425998110 div.yiv7425998110file-title a, #yiv7425998110
div.yiv7425998110file-title a:active, #yiv7425998110
div.yiv7425998110file-title a:hover, #yiv7425998110 div.yiv7425998110file-title
a:visited {text-decoration:none;}#yiv7425998110 div.yiv7425998110photo-title a,
#yiv7425998110 div.yiv7425998110photo-title a:active, #yiv7425998110
div.yiv7425998110photo-title a:hover, #yiv7425998110
div.yiv7425998110photo-title a:visited {text-decoration:none;}#yiv7425998110
div#yiv7425998110ygrp-mlmsg #yiv7425998110ygrp-msg p a
span.yiv7425998110yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7425998110
.yiv7425998110green {color:#628c2a;}#yiv7425998110 .yiv7425998110MsoNormal
{margin:0 0 0 0;}#yiv7425998110 o {font-size:0;}#yiv7425998110
#yiv7425998110photos div {float:left;width:72px;}#yiv7425998110
#yiv7425998110photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7425998110
#yiv7425998110photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7425998110
#yiv7425998110reco-category {font-size:77%;}#yiv7425998110
#yiv7425998110reco-desc {font-size:77%;}#yiv7425998110 .yiv7425998110replbq
{margin:4px;}#yiv7425998110 #yiv7425998110ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7425998110 #yiv7425998110ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7425998110
#yiv7425998110ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7425998110
#yiv7425998110ygrp-mlmsg select, #yiv7425998110 input, #yiv7425998110 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7425998110
#yiv7425998110ygrp-mlmsg pre, #yiv7425998110 code {font:115%
monospace;}#yiv7425998110 #yiv7425998110ygrp-mlmsg *
{line-height:1.22em;}#yiv7425998110 #yiv7425998110ygrp-mlmsg #yiv7425998110logo
{padding-bottom:10px;}#yiv7425998110 #yiv7425998110ygrp-msg p a
{font-family:Verdana;}#yiv7425998110 #yiv7425998110ygrp-msg
p#yiv7425998110attach-count span {color:#1E66AE;font-weight:700;}#yiv7425998110
#yiv7425998110ygrp-reco #yiv7425998110reco-head
{color:#ff7900;font-weight:700;}#yiv7425998110 #yiv7425998110ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7425998110 #yiv7425998110ygrp-sponsor
#yiv7425998110ov li a {font-size:130%;text-decoration:none;}#yiv7425998110
#yiv7425998110ygrp-sponsor #yiv7425998110ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7425998110
#yiv7425998110ygrp-sponsor #yiv7425998110ov ul {margin:0;padding:0 0 0
8px;}#yiv7425998110 #yiv7425998110ygrp-text
{font-family:Georgia;}#yiv7425998110 #yiv7425998110ygrp-text p {margin:0 0 1em
0;}#yiv7425998110 #yiv7425998110ygrp-text tt {font-size:120%;}#yiv7425998110
#yiv7425998110ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7425998110
