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
#yiv6806981338 #yiv6806981338 -- #yiv6806981338ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6806981338
#yiv6806981338ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6806981338
#yiv6806981338ygrp-mkp #yiv6806981338hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6806981338 #yiv6806981338ygrp-mkp #yiv6806981338ads
{margin-bottom:10px;}#yiv6806981338 #yiv6806981338ygrp-mkp .yiv6806981338ad
{padding:0 0;}#yiv6806981338 #yiv6806981338ygrp-mkp .yiv6806981338ad p
{margin:0;}#yiv6806981338 #yiv6806981338ygrp-mkp .yiv6806981338ad a
{color:#0000ff;text-decoration:none;}#yiv6806981338 #yiv6806981338ygrp-sponsor
#yiv6806981338ygrp-lc {font-family:Arial;}#yiv6806981338
#yiv6806981338ygrp-sponsor #yiv6806981338ygrp-lc #yiv6806981338hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6806981338
#yiv6806981338ygrp-sponsor #yiv6806981338ygrp-lc .yiv6806981338ad
{margin-bottom:10px;padding:0 0;}#yiv6806981338 #yiv6806981338actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6806981338
#yiv6806981338activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6806981338
#yiv6806981338activity span {font-weight:700;}#yiv6806981338
#yiv6806981338activity span:first-child
{text-transform:uppercase;}#yiv6806981338 #yiv6806981338activity span a
{color:#5085b6;text-decoration:none;}#yiv6806981338 #yiv6806981338activity span
span {color:#ff7900;}#yiv6806981338 #yiv6806981338activity span
.yiv6806981338underline {text-decoration:underline;}#yiv6806981338
.yiv6806981338attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6806981338 .yiv6806981338attach div a
{text-decoration:none;}#yiv6806981338 .yiv6806981338attach img
{border:none;padding-right:5px;}#yiv6806981338 .yiv6806981338attach label
{display:block;margin-bottom:5px;}#yiv6806981338 .yiv6806981338attach label a
{text-decoration:none;}#yiv6806981338 blockquote {margin:0 0 0
4px;}#yiv6806981338 .yiv6806981338bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6806981338
.yiv6806981338bold a {text-decoration:none;}#yiv6806981338 dd.yiv6806981338last
p a {font-family:Verdana;font-weight:700;}#yiv6806981338 dd.yiv6806981338last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6806981338
dd.yiv6806981338last p span.yiv6806981338yshortcuts
{margin-right:0;}#yiv6806981338 div.yiv6806981338attach-table div div a
{text-decoration:none;}#yiv6806981338 div.yiv6806981338attach-table
{width:400px;}#yiv6806981338 div.yiv6806981338file-title a, #yiv6806981338
div.yiv6806981338file-title a:active, #yiv6806981338
div.yiv6806981338file-title a:hover, #yiv6806981338 div.yiv6806981338file-title
a:visited {text-decoration:none;}#yiv6806981338 div.yiv6806981338photo-title a,
#yiv6806981338 div.yiv6806981338photo-title a:active, #yiv6806981338
div.yiv6806981338photo-title a:hover, #yiv6806981338
div.yiv6806981338photo-title a:visited {text-decoration:none;}#yiv6806981338
div#yiv6806981338ygrp-mlmsg #yiv6806981338ygrp-msg p a
span.yiv6806981338yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6806981338
.yiv6806981338green {color:#628c2a;}#yiv6806981338 .yiv6806981338MsoNormal
{margin:0 0 0 0;}#yiv6806981338 o {font-size:0;}#yiv6806981338
#yiv6806981338photos div {float:left;width:72px;}#yiv6806981338
#yiv6806981338photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv6806981338
#yiv6806981338photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6806981338
#yiv6806981338reco-category {font-size:77%;}#yiv6806981338
#yiv6806981338reco-desc {font-size:77%;}#yiv6806981338 .yiv6806981338replbq
{margin:4px;}#yiv6806981338 #yiv6806981338ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6806981338 #yiv6806981338ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6806981338
#yiv6806981338ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6806981338
#yiv6806981338ygrp-mlmsg select, #yiv6806981338 input, #yiv6806981338 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6806981338
#yiv6806981338ygrp-mlmsg pre, #yiv6806981338 code {font:115%
monospace;}#yiv6806981338 #yiv6806981338ygrp-mlmsg *
{line-height:1.22em;}#yiv6806981338 #yiv6806981338ygrp-mlmsg #yiv6806981338logo
{padding-bottom:10px;}#yiv6806981338 #yiv6806981338ygrp-msg p a
{font-family:Verdana;}#yiv6806981338 #yiv6806981338ygrp-msg
p#yiv6806981338attach-count span {color:#1E66AE;font-weight:700;}#yiv6806981338
#yiv6806981338ygrp-reco #yiv6806981338reco-head
{color:#ff7900;font-weight:700;}#yiv6806981338 #yiv6806981338ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6806981338 #yiv6806981338ygrp-sponsor
#yiv6806981338ov li a {font-size:130%;text-decoration:none;}#yiv6806981338
#yiv6806981338ygrp-sponsor #yiv6806981338ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6806981338
#yiv6806981338ygrp-sponsor #yiv6806981338ov ul {margin:0;padding:0 0 0
8px;}#yiv6806981338 #yiv6806981338ygrp-text
{font-family:Georgia;}#yiv6806981338 #yiv6806981338ygrp-text p {margin:0 0 1em
0;}#yiv6806981338 #yiv6806981338ygrp-text tt {font-size:120%;}#yiv6806981338
#yiv6806981338ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6806981338
