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 ^^*
#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
