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' mr.nm...@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> 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 shenly_excelma...@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com>: 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 ^^* #yiv1829239004 #yiv1829239004 -- #yiv1829239004ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1829239004 #yiv1829239004ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1829239004 #yiv1829239004ygrp-mkp #yiv1829239004hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1829239004 #yiv1829239004ygrp-mkp #yiv1829239004ads {margin-bottom:10px;}#yiv1829239004 #yiv1829239004ygrp-mkp .yiv1829239004ad {padding:0 0;}#yiv1829239004 #yiv1829239004ygrp-mkp .yiv1829239004ad p {margin:0;}#yiv1829239004 #yiv1829239004ygrp-mkp .yiv1829239004ad a {color:#0000ff;text-decoration:none;}#yiv1829239004 #yiv1829239004ygrp-sponsor #yiv1829239004ygrp-lc {font-family:Arial;}#yiv1829239004 #yiv1829239004ygrp-sponsor #yiv1829239004ygrp-lc #yiv1829239004hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1829239004 #yiv1829239004ygrp-sponsor #yiv1829239004ygrp-lc .yiv1829239004ad {margin-bottom:10px;padding:0 0;}#yiv1829239004 #yiv1829239004actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1829239004 #yiv1829239004activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1829239004 #yiv1829239004activity span {font-weight:700;}#yiv1829239004 #yiv1829239004activity span:first-child {text-transform:uppercase;}#yiv1829239004 #yiv1829239004activity span a {color:#5085b6;text-decoration:none;}#yiv1829239004 #yiv1829239004activity span span {color:#ff7900;}#yiv1829239004 #yiv1829239004activity span .yiv1829239004underline {text-decoration:underline;}#yiv1829239004 .yiv1829239004attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1829239004 .yiv1829239004attach div a {text-decoration:none;}#yiv1829239004 .yiv1829239004attach img {border:none;padding-right:5px;}#yiv1829239004 .yiv1829239004attach label {display:block;margin-bottom:5px;}#yiv1829239004 .yiv1829239004attach label a {text-decoration:none;}#yiv1829239004 blockquote {margin:0 0 0 4px;}#yiv1829239004 .yiv1829239004bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1829239004 .yiv1829239004bold a {text-decoration:none;}#yiv1829239004 dd.yiv1829239004last p a {font-family:Verdana;font-weight:700;}#yiv1829239004 dd.yiv1829239004last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1829239004 dd.yiv1829239004last p span.yiv1829239004yshortcuts {margin-right:0;}#yiv1829239004 div.yiv1829239004attach-table div div a {text-decoration:none;}#yiv1829239004 div.yiv1829239004attach-table {width:400px;}#yiv1829239004 div.yiv1829239004file-title a, #yiv1829239004 div.yiv1829239004file-title a:active, #yiv1829239004 div.yiv1829239004file-title a:hover, #yiv1829239004 div.yiv1829239004file-title a:visited {text-decoration:none;}#yiv1829239004 div.yiv1829239004photo-title a, #yiv1829239004 div.yiv1829239004photo-title a:active, #yiv1829239004 div.yiv1829239004photo-title a:hover, #yiv1829239004 div.yiv1829239004photo-title a:visited {text-decoration:none;}#yiv1829239004 div#yiv1829239004ygrp-mlmsg #yiv1829239004ygrp-msg p a span.yiv1829239004yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1829239004 .yiv1829239004green {color:#628c2a;}#yiv1829239004 .yiv1829239004MsoNormal {margin:0 0 0 0;}#yiv1829239004 o {font-size:0;}#yiv1829239004 #yiv1829239004photos div {float:left;width:72px;}#yiv1829239004 #yiv1829239004photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv1829239004 #yiv1829239004photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1829239004 #yiv1829239004reco-category {font-size:77%;}#yiv1829239004 #yiv1829239004reco-desc {font-size:77%;}#yiv1829239004 .yiv1829239004replbq {margin:4px;}#yiv1829239004 #yiv1829239004ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1829239004 #yiv1829239004ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1829239004 #yiv1829239004ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1829239004 #yiv1829239004ygrp-mlmsg select, #yiv1829239004 input, #yiv1829239004 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1829239004 #yiv1829239004ygrp-mlmsg pre, #yiv1829239004 code {font:115% monospace;}#yiv1829239004 #yiv1829239004ygrp-mlmsg * {line-height:1.22em;}#yiv1829239004 #yiv1829239004ygrp-mlmsg #yiv1829239004logo {padding-bottom:10px;}#yiv1829239004 #yiv1829239004ygrp-msg p a {font-family:Verdana;}#yiv1829239004 #yiv1829239004ygrp-msg p#yiv1829239004attach-count span {color:#1E66AE;font-weight:700;}#yiv1829239004 #yiv1829239004ygrp-reco #yiv1829239004reco-head {color:#ff7900;font-weight:700;}#yiv1829239004 #yiv1829239004ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1829239004 #yiv1829239004ygrp-sponsor #yiv1829239004ov li a {font-size:130%;text-decoration:none;}#yiv1829239004 #yiv1829239004ygrp-sponsor #yiv1829239004ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1829239004 #yiv1829239004ygrp-sponsor #yiv1829239004ov ul {margin:0;padding:0 0 0 8px;}#yiv1829239004 #yiv1829239004ygrp-text {font-family:Georgia;}#yiv1829239004 #yiv1829239004ygrp-text p {margin:0 0 1em 0;}#yiv1829239004 #yiv1829239004ygrp-text tt {font-size:120%;}#yiv1829239004 #yiv1829239004ygrp-vital ul li:last-child {border-right:none !important;}#yiv1829239004