Kalo seting reg pc nya English, tentu penulisan "Text" nya harus diubah
dulu...bukan
| 04 JULI 1997 |
tetapi
| JULY 04, 1997 |
kalau format hasilnya mau tetap diperthankan sebagai data tanggal
Salam,HK
From: "Andre Rahmaidy [email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Tuesday, 28 July 2015, 13:58
Subject: Bls: [belajar-excel] Trs: Formula Format Tanggal
Dear Pak Hendrik
Terimkasih atas infonya pak.. kalau regional settingnya ga dirubah emang ga
bisa jalan formula DATEVALUEnya pak?? kebetulan seting regional pc saya harus
english pak.
Pada Selasa, 28 Juli 2015 13:37, "hendrik karnadi [email protected]
[belajar-excel]" <[email protected]> menulis:
Hai Andree,Sdh cek regional settingnya ?
Salam,HK
----- Forwarded Message -----
From: "Andre Rahmaidy [email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Tuesday, 28 July 2015, 13:02
Subject: [belajar-excel] Trs: Formula Format Tanggal
Dear Beexceller
terimakasih atas bantuan formulanya, cuma di ms office saya fungsi DATEVALUE
kok berubah jadi eror ya seperti ini #value!..
Wassalam
Andree
#yiv5847203233 #yiv5847203233 -- #yiv5847203233ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5847203233
#yiv5847203233ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5847203233
#yiv5847203233ygrp-mkp #yiv5847203233hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5847203233 #yiv5847203233ygrp-mkp #yiv5847203233ads
{margin-bottom:10px;}#yiv5847203233 #yiv5847203233ygrp-mkp .yiv5847203233ad
{padding:0 0;}#yiv5847203233 #yiv5847203233ygrp-mkp .yiv5847203233ad p
{margin:0;}#yiv5847203233 #yiv5847203233ygrp-mkp .yiv5847203233ad a
{color:#0000ff;text-decoration:none;}#yiv5847203233 #yiv5847203233ygrp-sponsor
#yiv5847203233ygrp-lc {font-family:Arial;}#yiv5847203233
#yiv5847203233ygrp-sponsor #yiv5847203233ygrp-lc #yiv5847203233hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5847203233
#yiv5847203233ygrp-sponsor #yiv5847203233ygrp-lc .yiv5847203233ad
{margin-bottom:10px;padding:0 0;}#yiv5847203233 #yiv5847203233actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5847203233
#yiv5847203233activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5847203233
#yiv5847203233activity span {font-weight:700;}#yiv5847203233
#yiv5847203233activity span:first-child
{text-transform:uppercase;}#yiv5847203233 #yiv5847203233activity span a
{color:#5085b6;text-decoration:none;}#yiv5847203233 #yiv5847203233activity span
span {color:#ff7900;}#yiv5847203233 #yiv5847203233activity span
.yiv5847203233underline {text-decoration:underline;}#yiv5847203233
.yiv5847203233attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5847203233 .yiv5847203233attach div a
{text-decoration:none;}#yiv5847203233 .yiv5847203233attach img
{border:none;padding-right:5px;}#yiv5847203233 .yiv5847203233attach label
{display:block;margin-bottom:5px;}#yiv5847203233 .yiv5847203233attach label a
{text-decoration:none;}#yiv5847203233 blockquote {margin:0 0 0
4px;}#yiv5847203233 .yiv5847203233bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5847203233
.yiv5847203233bold a {text-decoration:none;}#yiv5847203233 dd.yiv5847203233last
p a {font-family:Verdana;font-weight:700;}#yiv5847203233 dd.yiv5847203233last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5847203233
dd.yiv5847203233last p span.yiv5847203233yshortcuts
{margin-right:0;}#yiv5847203233 div.yiv5847203233attach-table div div a
{text-decoration:none;}#yiv5847203233 div.yiv5847203233attach-table
{width:400px;}#yiv5847203233 div.yiv5847203233file-title a, #yiv5847203233
div.yiv5847203233file-title a:active, #yiv5847203233
div.yiv5847203233file-title a:hover, #yiv5847203233 div.yiv5847203233file-title
a:visited {text-decoration:none;}#yiv5847203233 div.yiv5847203233photo-title a,
#yiv5847203233 div.yiv5847203233photo-title a:active, #yiv5847203233
div.yiv5847203233photo-title a:hover, #yiv5847203233
div.yiv5847203233photo-title a:visited {text-decoration:none;}#yiv5847203233
div#yiv5847203233ygrp-mlmsg #yiv5847203233ygrp-msg p a
span.yiv5847203233yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5847203233
.yiv5847203233green {color:#628c2a;}#yiv5847203233 .yiv5847203233MsoNormal
{margin:0 0 0 0;}#yiv5847203233 o {font-size:0;}#yiv5847203233
#yiv5847203233photos div {float:left;width:72px;}#yiv5847203233
#yiv5847203233photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv5847203233
#yiv5847203233photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5847203233
#yiv5847203233reco-category {font-size:77%;}#yiv5847203233
#yiv5847203233reco-desc {font-size:77%;}#yiv5847203233 .yiv5847203233replbq
{margin:4px;}#yiv5847203233 #yiv5847203233ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5847203233 #yiv5847203233ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5847203233
#yiv5847203233ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5847203233
#yiv5847203233ygrp-mlmsg select, #yiv5847203233 input, #yiv5847203233 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5847203233
#yiv5847203233ygrp-mlmsg pre, #yiv5847203233 code {font:115%
monospace;}#yiv5847203233 #yiv5847203233ygrp-mlmsg *
{line-height:1.22em;}#yiv5847203233 #yiv5847203233ygrp-mlmsg #yiv5847203233logo
{padding-bottom:10px;}#yiv5847203233 #yiv5847203233ygrp-msg p a
{font-family:Verdana;}#yiv5847203233 #yiv5847203233ygrp-msg
p#yiv5847203233attach-count span {color:#1E66AE;font-weight:700;}#yiv5847203233
#yiv5847203233ygrp-reco #yiv5847203233reco-head
{color:#ff7900;font-weight:700;}#yiv5847203233 #yiv5847203233ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv5847203233 #yiv5847203233ygrp-sponsor
#yiv5847203233ov li a {font-size:130%;text-decoration:none;}#yiv5847203233
#yiv5847203233ygrp-sponsor #yiv5847203233ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5847203233
#yiv5847203233ygrp-sponsor #yiv5847203233ov ul {margin:0;padding:0 0 0
8px;}#yiv5847203233 #yiv5847203233ygrp-text
{font-family:Georgia;}#yiv5847203233 #yiv5847203233ygrp-text p {margin:0 0 1em
0;}#yiv5847203233 #yiv5847203233ygrp-text tt {font-size:120%;}#yiv5847203233
#yiv5847203233ygrp-vital ul li:last-child {border-right:none
!important;}#yiv5847203233
