{"id":1505,"date":"2015-04-23T17:38:11","date_gmt":"2015-04-23T08:38:11","guid":{"rendered":"http:\/\/excelwork.info\/excel\/?p=1505"},"modified":"2015-12-30T10:24:22","modified_gmt":"2015-12-30T01:24:22","slug":"format","status":"publish","type":"post","link":"https:\/\/excelwork.info\/excel\/format\/","title":{"rendered":"\u66f8\u5f0f\u3092\u5909\u63db\uff08Format \u95a2\u6570\uff09"},"content":{"rendered":"<h2>Format \u95a2\u6570\u306e\u4f7f\u3044\u65b9<\/h2>\n<br \/>\n<div class=\"m30-l\">\n<div class=\"kkbox\"><strong>\u3010\u66f8\u5f0f\u3011<\/strong><\/p>\n<p><em>result<\/em> = <strong>Format<\/strong> ( <em>expression<\/em> [ , <em>format<\/em>, <em>firstdayofweek<\/em>, <em>firstweekofyear<\/em> ] )<\/p>\n<\/div>\n<br \/>\n<h3>\u5f15\u6570\u30fb\u623b\u308a\u5024<\/h3>\n<ul style=\"margin-top:0;margin-bottom:0;padding-top:0;padding-bottom:0;\">\n<li>expression&nbsp;&nbsp;\u30fb\u30fb\u30fb&nbsp;&nbsp;\u5909\u63db\u5143\u306e\u4efb\u610f\u306e\u5f0f\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/li>\n<li>format&nbsp;&nbsp;\u30fb\u30fb\u30fb&nbsp;&nbsp;\u5f15\u6570 <em>expression<\/em> \u3092\u5909\u63db\u3059\u308b\u66f8\u5f0f\uff08<a href=\"#Format_table2\">\u5b9a\u7fa9\u6e08\u307f\u66f8\u5f0f<\/a>\u307e\u305f\u306f<a href=\"#Format_table\">\u8868\u793a\u66f8\u5f0f\u6307\u5b9a\u6587\u5b57<\/a>\uff09\u3092\u6307\u5b9a\u3057\u307e\u3059\uff08\u7701\u7565\u53ef \u21d2 <strong>Str \u95a2\u6570<\/strong> \u306e\u5b9f\u884c\u7d50\u679c\u306b\u6e96\u3058\u305f\u5024\u3092\u8fd4\u3057\u307e\u3059\uff09\u3002<\/li>\n<li>firstdayofweek&nbsp;&nbsp;\u30fb\u30fb\u30fb&nbsp;&nbsp;<strong>\u9031\u306e\u59cb\u307e\u308a\u306e\u66dc\u65e5\u3092\u8868\u3059\u5b9a\u6570<\/strong>\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u7701\u7565\u3059\u308b\u3068\u65e5\u66dc\u65e5\u3092\u6307\u5b9a\u3057\u305f\u3082\u306e\u3068\u307f\u306a\u3055\u308c\u307e\u3059\uff08\u300c<a href=\"#format_firstdayofweek\">\u9031\u306e\u59cb\u307e\u308a\u306e\u66dc\u65e5\u3092\u793a\u3059\u5b9a\u6570<\/a>\u300d\u3092\u53c2\u7167 \uff09\u3002<\/li>\n<li>firstweekofyear&nbsp;&nbsp;\u30fb\u30fb\u30fb&nbsp;&nbsp;<strong>\u5e74\u5ea6\u306e\u7b2c 1 \u9031\u3092\u8868\u3059\u5b9a\u6570<\/strong>\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u7701\u7565\u3059\u308b\u3068\u30011 \u6708 1 \u65e5\u3092\u542b\u3080\u9031\u304c\u7b2c 1 \u9031\u3068\u307f\u306a\u3055\u308c\u307e\u3059\uff08\u300c<a href=\"#format_firstweekofyear\">\u5e74\u5ea6\u306e\u59cb\u307e\u308a\u3092\u793a\u3059\u5b9a\u6570<\/a>\u300d\u3092\u53c2\u7167 \uff09\u3002<\/li>\n<li>result&nbsp;&nbsp;\u30fb\u30fb\u30fb&nbsp;&nbsp;\u5f15\u6570 <em>expression<\/em> \u3092 <em>format<\/em> \u3067\u6307\u5b9a\u3057\u305f\u66f8\u5f0f\u306b\u5909\u63db\u3001\u305d\u306e\u6587\u5b57\u5217\u3092\u793a\u3059\u30d0\u30ea\u30a2\u30f3\u30c8\u578b (\u5185\u90e8\u51e6\u7406\u5f62\u5f0f String) \u306e\u5024\u3002<\/li>\n<\/ul>\n<br \/><br \/>\n<p class=\"caution4\"><span class=\"red\"><strong>\u8907\u6570\u306e\u7a2e\u985e\u306e\u66f8\u5f0f\u3092\u6307\u5b9a\u3059\u308b\uff08\u6570\u5024\uff09<\/strong><\/span><br \/>\n<a href=\"#Format_table\">\u8868\u793a\u66f8\u5f0f\u6307\u5b9a\u6587\u5b57<\/a>\u3092\u4f7f\u3063\u3066\u6570\u5024\u3092\u6587\u5b57\u5217\u306b\u5909\u63db\u3059\u308b\u5834\u5408\u306f\u3001\u5f15\u6570 <em>format<\/em> \u306b\u306f\u3001<strong>\u30bb\u30df\u30b3\u30ed\u30f3\uff08;\uff09\u3067\u533a\u5207\u308b\u3053\u3068\u306b\u3088\u308a<span class=\"red\">\u6700\u59274\u7a2e\u985e\u306e\u66f8\u5f0f<\/span>\u3092\u6307\u5b9a<\/strong>\u3067\u304d\u307e\u3059\u3002\u305f\u3060\u3057\u3001\u5f15\u6570 format \u306b<a href=\"#Format_table2\">\u5b9a\u7fa9\u6e08\u307f\u66f8\u5f0f<\/a>\u304c\u542b\u307e\u308c\u308b\u5834\u5408\u3001\u6307\u5b9a\u3067\u304d\u308b\u66f8\u5f0f\u306f 1 \u3064\u3060\u3051\u3067\u3059\u3002<br \/>\n\u307e\u305f\u3001\u8907\u6570\u306e\u30bb\u30df\u30b3\u30ed\u30f3\uff08;\uff09\u306e\u9593\u306b\u4f55\u3082\u8a18\u8ff0\u3057\u306a\u3044\u5834\u5408\u306b\u306f\u3001\u305d\u306e\u7a7a\u306e\u66f8\u5f0f\u306b\u5bfe\u5fdc\u3059\u308b\u6570\u5024\u306f\u3001<strong>\u6b63\u306e\u6570\u5024\u7528\u306e\u66f8\u5f0f<\/strong>\u3092\u4f7f\u3063\u3066\u5909\u63db\u3055\u308c\u307e\u3059<\/p>\n<div class=\"m30-l\">\n<table>\n<tr>\n<td align = \"center\" width=\"50\"><strong>\u66f8\u5f0f\u6570<\/strong><\/td>\n<td align = \"center\" width=\"600\"><strong><\/strong><\/td>\n<\/tr>\n<tr>\n<td align = \"center\">1<\/td>\n<td>\u5e38\u306b\u305d\u306e\u66f8\u5f0f\u3092\u4f7f\u7528<\/td>\n<\/tr>\n<tr>\n<td align = \"center\">2<\/td>\n<td>\u6570\u5024 &gt;= 0 \u21d2 1 \u756a\u76ee\u306e\u66f8\u5f0f \uff0f \u6570\u5024 &lt; 0 \u21d2 2 \u756a\u76ee\u306e\u66f8\u5f0f<\/td>\n<\/tr>\n<tr>\n<td align = \"center\">3<\/td>\n<td>\u6570\u5024 &gt; 0 \u21d2 1 \u756a\u76ee\u306e\u66f8\u5f0f \uff0f \u6570\u5024 &lt; 0 \u21d2 2 \u756a\u76ee\u306e\u66f8\u5f0f \uff0f \u6570\u5024 = 0 \u21d2 3 \u756a\u76ee\u306e\u66f8\u5f0f<\/td>\n<\/tr>\n<tr>\n<td align = \"center\">4<\/td>\n<td>\u6570\u5024 &gt; 0 \u21d2 1 \u756a\u76ee\u306e\u66f8\u5f0f \uff0f \u6570\u5024 &lt; 0 \u21d2 2 \u756a\u76ee\u306e\u66f8\u5f0f \uff0f \u6570\u5024 = 0 \u21d2 3 \u756a\u76ee\u306e\u66f8\u5f0f \uff0f \u6570\u5024\u304c Null \u5024 \u21d2 4 \u756a\u76ee\u306e\u66f8\u5f0f<\/td>\n<\/tr>\n<\/table>\n<\/div>\n<br \/><br \/>\n<p class=\"caution4\"><span class=\"red\"><strong>\u8907\u6570\u306e\u7a2e\u985e\u306e\u66f8\u5f0f\u3092\u6307\u5b9a\u3059\u308b\uff08\u6587\u5b57\u5217\uff09<\/strong><\/span><br \/>\n  \u6587\u5b57\u5217\u306e\u66f8\u5f0f\u6307\u5b9a\u3067\u3082\u30bb\u30df\u30b3\u30ed\u30f3\uff08;\uff09\u3067\u533a\u5207\u308b\u3053\u3068\u306b\u3088\u308a\u8907\u6570\u306e\u66f8\u5f0f\uff08<span class=\"red\"><strong>\u6700\u59272\u7a2e\u985e<\/strong><\/span>\uff09\u3092\u5f15\u6570 <em>format<\/em> \u306b\u6307\u5b9a\u3067\u304d\u307e\u3059\u3002<\/p>\n<div class=\"m30-l\">\n<table>\n<tr>\n<td align = \"center\" width=\"50\"><strong>\u66f8\u5f0f\u6570<\/strong><\/td>\n<td align = \"center\" width=\"600\"><strong><\/strong><\/td>\n<\/tr>\n<tr>\n<td align = \"center\">1<\/td>\n<td>\u5e38\u306b\u305d\u306e\u66f8\u5f0f\u3092\u4f7f\u7528<\/td>\n<\/tr>\n<tr>\n<td align = \"center\">2<\/td>\n<td>\u901a\u5e38 \u21d2 1 \u756a\u76ee\u306e\u66f8\u5f0f \uff0f Null \u5024\u307e\u305f\u306f\u9577\u3055 0 \u306e\u6587\u5b57\u5217(&#8220;&#8221;) \u21d2 2 \u756a\u76ee\u306e\u66f8\u5f0f<\/td>\n<\/tr>\n<\/table>\n<\/div>\n<br \/><br \/>\n<p id=\"Format_table\" class=\"caution4\"><strong>\u66f8\u5f0f\u3092\u6307\u5b9a\u3059\u308b\u6642\u306b\u4f7f\u7528\u3067\u304d\u308b\u8a18\u53f7\u7b49<\/strong><\/p>\n<div class=\"m30-l\">\n<table>\n<tr>\n<td bgcolor=\"#ccffcc\" width=\"80\" align = \"center\" rowspan=\"2\"><strong>\u8a18\u53f7<\/strong><\/td>\n<td bgcolor=\"#ccffcc\" width=\"180\" align = \"center\" rowspan=\"2\"><strong>\u5185\u5bb9<\/strong><\/td>\n<td bgcolor=\"#ccffcc\" width=\"300\" align = \"center\" colspan=\"3\"><strong>\u4f7f\u7528\u4f8b<\/strong><\/td>\n<td bgcolor=\"#ccffcc\" width=\"40\" align = \"center\" rowspan=\"2\"><strong>\u8868\u793a\u66f8\u5f0f<\/strong><\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ccffcc\" width=\"100\" align = \"center\"><strong>\u5165\u529b\u5024<\/strong><\/td>\n<td bgcolor=\"#ccffcc\" width=\"100\" align = \"center\"><strong>\u66f8\u5f0f<\/strong><\/td>\n<td bgcolor=\"#ccffcc\" width=\"100\" align = \"center\"><strong>\u7d50\u679c<\/strong><\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#eeffff\" width=\"80\" align = \"center\">\u306a\u3057<\/td>\n<td bgcolor=\"#eeffff\" width=\"180\" >\u6307\u5b9a\u3057\u305f\u6570\u5024\u3092\u305d\u306e\u307e\u307e\u3067\u8fd4\u3059\uff08\u6587\u5b57\u5217\uff09<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">125.25<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\"><\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">125.25<\/td>\n<td bgcolor=\"#eeffff\" width=\"40\" align = \"center\" rowspan=\"16\">\u6570\u5024<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#eeffff\" width=\"80\" align = \"center\" rowspan=\"2\">0<\/td>\n<td bgcolor=\"#eeffff\" width=\"180\" rowspan=\"2\">\u6570\u5024\uff11\u6841\u300c0\u300d\u8868\u793a<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\" rowspan=\"2\">125.25<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">&#8220;0000.0&#8221;<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">0125.3<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">&#8220;0.000&#8221;<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">125.250<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#eeffff\" width=\"80\" align = \"center\" rowspan=\"2\">#<\/td>\n<td bgcolor=\"#eeffff\" width=\"180\" rowspan=\"2\">\u6570\u5024\uff11\u6841\u300c0\u300d\u975e\u8868\u793a<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\" rowspan=\"2\">125.25<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">&#8220;####.#<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">125.3<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">&#8220;#.###<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">125.25<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#eeffff\" width=\"80\" align = \"center\">%<\/td>\n<td bgcolor=\"#eeffff\" width=\"180\" >\u6570\u5024\u3092100\u500d\u3057\u3066\u300c%\u300d\u3092\u3064\u3051\u308b<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">0.365<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">&#8220;#.#0%&#8221;<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">36.50%<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#eeffff\" width=\"80\" align = \"center\" rowspan=\"3\">,<\/td>\n<td bgcolor=\"#eeffff\" width=\"180\" rowspan=\"3\">1000\u5358\u4f4d\u306e\u533a\u5207\u308a\u8a18\u53f7\u633f\u5165<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\" rowspan=\"3\">1259900<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">&#8220;#,#&#8221;<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">1,259,900<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">#,#,\u5343\u5186<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">1,260\u5343\u5186<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">0,0<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">1,259,900<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#eeffff\" width=\"80\" align = \"center\" rowspan=\"3\">E+ e+<\/td>\n<td bgcolor=\"#eeffff\" width=\"180\" rowspan=\"3\">\u6307\u6570\u8868\u8a18\uff08\u6307\u6570\u306e\u6b63\u8ca0\u306b\u3042\u308f\u305b\u3066 + &#8211; \u306e\u8a18\u53f7\u304c\u4ed8\u304f<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">100000000<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">&#8220;0.00e+&#8221;<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">1.00e+8<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">-100000000<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">&#8220;0.00e+&#8221;<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">-1.00e+8<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">0.5<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">&#8220;0.00e+&#8221;<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">5.00e-1<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#eeffff\" width=\"80\" align = \"center\" rowspan=\"3\">E- e-<\/td>\n<td bgcolor=\"#eeffff\" width=\"180\" rowspan=\"3\">\u6307\u6570\u8868\u8a18\uff08\u6307\u6570\u304c\u8ca0\u306e\u6642\u3001- \u306e\u8a18\u53f7\u304c\u4ed8\u304f<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">2500<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">&#8220;0.00e-&#8220;<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">2.50e3<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">-100000000<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">&#8220;0.00e-&#8220;<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">-1.00e8<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">0.5<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">&#8220;0.00e-&#8220;<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">5.00e-1<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#eeffff\" width=\"80\" align = \"center\">\\<\/td>\n<td bgcolor=\"#eeffff\" width=\"180\" >\\,#,E \u7b49\u306e\u7279\u5225\u306a\u610f\u5473\u3092\u3082\u3064\u6587\u5b57\u3092\u8868\u793a\u3059\u308b\u306b\u306f\u3001\u305d\u306e\u524d\u306b\u300c\\\u300d\u3092\u4ed8\u3051\u308b<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">1000<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">&#8220;\\\\#,#&#8221;<\/td>\n<td bgcolor=\"#eeffff\" width=\"100\" align = \"center\">\\1,000<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffffee\" width=\"80\" align = \"center\">@<\/td>\n<td bgcolor=\"#ffffee\" width=\"180\" >1\u6587\u5b57\u307e\u305f\u306f\u30b9\u30da\u30fc\u30b9\uff08@ \u306e\u4f4d\u7f6e\u306b\u5bfe\u5fdc\u3059\u308b\u6587\u5b57\u304c\u306a\u3044\u5834\u5408\uff09<\/td>\n<td bgcolor=\"#ffffee\" width=\"100\" align = \"center\">1<\/td>\n<td bgcolor=\"#ffffee\" width=\"100\" align = \"center\">&#8220;@@\u6708&#8221;<\/td>\n<td bgcolor=\"#ffffee\" width=\"100\" align = \"center\">\u30001\u6708<\/td>\n<td bgcolor=\"#ffffee\" width=\"40\" align = \"center\" rowspan=\"5\">\u6587\u5b57\u5217<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffffee\" width=\"80\" align = \"center\">&#038;<\/td>\n<td bgcolor=\"#ffffee\" width=\"180\" >1\u6587\u5b57<\/td>\n<td bgcolor=\"#ffffee\" width=\"100\" align = \"center\">1<\/td>\n<td bgcolor=\"#ffffee\" width=\"100\" align = \"center\">&#8220;&#038;&#038;\u6708&#8221;<\/td>\n<td bgcolor=\"#ffffee\" width=\"100\" align = \"center\">1\u6708<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffffee\" width=\"80\" align = \"center\">&lt;<\/td>\n<td bgcolor=\"#ffffee\" width=\"180\" >\u5c0f\u6587\u5b57\u306b\u5909\u63db<\/td>\n<td bgcolor=\"#ffffee\" width=\"100\" align = \"center\">ABCDE<\/td>\n<td bgcolor=\"#ffffee\" width=\"100\" align = \"center\">&#8220;<\"<\/td>\n<td bgcolor=\"#ffffee\" width=\"100\" align = \"center\">abcde<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffffee\" width=\"80\" align = \"center\">&gt;<\/td>\n<td bgcolor=\"#ffffee\" width=\"180\" >\u5927\u6587\u5b57\u306b\u5909\u63db<\/td>\n<td bgcolor=\"#ffffee\" width=\"100\" align = \"center\">abcde<\/td>\n<td bgcolor=\"#ffffee\" width=\"100\" align = \"center\">&#8220;>&#8221;<\/td>\n<td bgcolor=\"#ffffee\" width=\"100\" align = \"center\">ABCDE<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffffee\" width=\"80\" align = \"center\">!<\/td>\n<td bgcolor=\"#ffffee\" width=\"180\" >\u6587\u5b57\u3092\u5de6\u304b\u3089\u53d6\u5f97<\/td>\n<td bgcolor=\"#ffffee\" width=\"100\" align = \"center\">abcde<\/td>\n<td bgcolor=\"#ffffee\" width=\"100\" align = \"center\">&#8220;@@!&#8221;<\/td>\n<td bgcolor=\"#ffffee\" width=\"100\" align = \"center\">de<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffeeff\" width=\"80\" align = \"center\" rowspan=\"3\">y<\/td>\n<td bgcolor=\"#ffeeff\" width=\"180\">\u5143\u65e6\u304b\u3089\u6570\u3048\u3066\u4f55\u65e5\u76ee\u304b<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\" rowspan=\"3\">#1\/1\/2015#<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">&#8220;y&#8221;<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">1<\/td>\n<td bgcolor=\"#ffeeff\" width=\"40\" align = \"center\" rowspan=\"31\">\u65e5\u4ed8\u6642\u523b<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffeeff\" width=\"180\">\u897f\u66a6\uff08\u4e0b2\u6841\u306e\u307f\u8868\u793a\uff09<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">&#8220;yy&#8221;<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">15<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffeeff\" width=\"180\">\u897f\u66a6\uff08\u4e0b4\u6841\u8868\u793a\uff09<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">&#8220;yyyy&#8221;<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">2015<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffeeff\" width=\"80\" align = \"center\" rowspan=\"4\">m<\/td>\n<td bgcolor=\"#ffeeff\" width=\"180\">\u6708<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\" rowspan=\"4\">#1\/1\/2015#<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">&#8220;m&#8221;<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">1<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffeeff\" width=\"180\">\u6708\uff081 \uff5e 9 \u6708\u306f\u524d\u306b\u300c0\u300d\u3092\u4ed8\u3051\u308b\uff09<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">&#8220;mm&#8221;<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">01<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffeeff\" width=\"180\">\u6708\uff08\u82f1\u8a9e\uff09\u77ed\u7e2e\u5f62<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">&#8220;mmm&#8221;<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">Jan<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffeeff\" width=\"180\">\u6708\uff08\u82f1\u8a9e\uff09\u5b8c\u5168\u5f62<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">&#8220;mmmm&#8221;<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">January<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffeeff\" width=\"80\" align = \"center\">o<\/td>\n<td bgcolor=\"#ffeeff\" width=\"180\">\u6708\uff08\u65e5\u672c\u8a9e\uff09<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">#1\/1\/2015#<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">&#8220;oooo&#8221;<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">1\u6708<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffeeff\" width=\"80\" align = \"center\" rowspan=\"6\">d<\/td>\n<td bgcolor=\"#ffeeff\" width=\"180\">\u65e5<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\" rowspan=\"6\">#1\/1\/2015#<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">&#8220;d&#8221;<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">1<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffeeff\" width=\"180\">\u65e5\uff081 \uff5e 9 \u65e5\u306f\u524d\u306b\u300c0\u300d\u3092\u4ed8\u3051\u308b\uff09<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">&#8220;dd&#8221;<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">01<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffeeff\" width=\"180\">\u66dc\u65e5\uff08\u82f1\u8a9e\uff09\u7701\u7565\u5f62<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">&#8220;ddd&#8221;<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">Thu<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffeeff\" width=\"180\">\u66dc\u65e5\uff08\u82f1\u8a9e\uff09\u5b8c\u5168\u5f62<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">&#8220;dddd&#8221;<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">Thursday<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffeeff\" width=\"180\">\u5e74\u6708\u65e5\u3092\u542b\u3080\u77ed\u3044\u5f62\u5f0f\uff08\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u30d1\u30cd\u30eb\u3067\u8a2d\u5b9a\uff09\u3067\u8868\u3057\u305f\u65e5\u4ed8<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">&#8220;ddddd&#8221;<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">2015\/01\/01<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffeeff\" width=\"180\">\u5e74\u6708\u65e5\u3092\u542b\u3080\u9577\u3044\u5f62\u5f0f\uff08\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u30d1\u30cd\u30eb\u3067\u8a2d\u5b9a\uff09\u3067\u8868\u3057\u305f\u65e5\u4ed8<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">&#8220;dddddd&#8221;<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">2015\u5e741\u67081\u65e5<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffeeff\" width=\"80\" align = \"center\" rowspan=\"2\">a<\/td>\n<td bgcolor=\"#ffeeff\" width=\"180\">\u66dc\u65e5\uff08\u65e5\u672c\u8a9e\uff09\u77ed\u7e2e\u5f62<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\" rowspan=\"2\">#1\/1\/2015#<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">&#8220;aaa&#8221;<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">\u6728<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffeeff\" width=\"180\">\u66dc\u65e5\uff08\u65e5\u672c\u8a9e\uff09\u5b8c\u5168\u5f62<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">&#8220;aaaa&#8221;<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">\u6728\u66dc\u65e5<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffeeff\" width=\"80\" align = \"center\" rowspan=\"2\">w<\/td>\n<td bgcolor=\"#ffeeff\" width=\"180\">\u66dc\u65e5\u3092\u793a\u3059\u5b9a\u6570\uff08\u9031\u306e1\u65e5\u76ee\u306f\u5f15\u6570 <em>firstdayofweek<\/em> \u3067\u6307\u5b9a\u53ef\uff09<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\" rowspan=\"2\">#1\/1\/2015#<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">&#8220;w&#8221;<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">5<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffeeff\" width=\"180\">\u9031\u521d\u3081\u304b\u3089\u6570\u3048\u3066\u4f55\u756a\u76ee\u304b\uff08\u5e74\u306e\u7b2c1\u9031\u76ee\u306f\u5f15\u6570 <em>firstweekofyear<\/em> \u3067\u6307\u5b9a\u53ef\uff09<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">&#8220;ww&#8221;<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">1<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffeeff\" width=\"80\" align = \"center\" rowspan=\"3\">g<\/td>\n<td bgcolor=\"#ffeeff\" width=\"180\">\u5e74\u53f7\uff08 \u982d\u6587\u5b57\uff1aM, T, S, H \uff09<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\" rowspan=\"3\">#1\/1\/2015#<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">&#8220;g&#8221;<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">H<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffeeff\" width=\"180\">\u5e74\u53f7\uff08 \u5148\u982d\u306e\u6f22\u5b57\uff11\u6587\u5b57\uff1a\u660e, \u5927, \u662d, \u5e73 \uff09<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">&#8220;gg&#8221;<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">\u5e73<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffeeff\" width=\"180\">\u5e74\u53f7\uff08\u660e\u6cbb, \u5927\u6b63, \u662d\u548c, \u5e73\u6210\uff09<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">&#8220;ggg&#8221;<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">\u5e73\u6210<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffeeff\" width=\"80\" align = \"center\" rowspan=\"2\">e<\/td>\n<td bgcolor=\"#ffeeff\" width=\"180\">\u548c\u66a6\u306e\u5e74<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\" rowspan=\"2\">#1\/1\/2015#<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">&#8220;e&#8221;<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">27<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffeeff\" width=\"180\">\u548c\u66a6\u306e\u5e74\uff081\u6841\u306e\u5834\u5408\u3001\u5148\u982d\u306b\u300c0\u300d\u304c\u4ed8\u304f\uff09<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">&#8220;ee&#8221;<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">27<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffeeff\" width=\"80\" align = \"center\" rowspan=\"2\">h<\/td>\n<td bgcolor=\"#ffeeff\" width=\"180\">\u6642\u9593<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\" rowspan=\"2\">#1:11:00 AM#<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">&#8220;h&#8221;<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">1<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffeeff\" width=\"180\">\u6642\u9593\uff081\u6841\u306e\u5834\u5408\u3001\u5148\u982d\u306b\u300c0\u300d\u304c\u4ed8\u304f\uff09<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">&#8220;hh&#8221;<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">01<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffeeff\" width=\"80\" align = \"center\" rowspan=\"2\">n<\/td>\n<td bgcolor=\"#ffeeff\" width=\"180\">\u5206<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\" rowspan=\"2\">#1:11:00 AM#<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">&#8220;n&#8221;<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">11<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffeeff\" width=\"180\">\u5206\uff081\u6841\u306e\u5834\u5408\u3001\u5148\u982d\u306b\u300c0\u300d\u304c\u4ed8\u304f\uff09<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">&#8220;nn&#8221;<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">11<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffeeff\" width=\"80\" align = \"center\" rowspan=\"2\">s<\/td>\n<td bgcolor=\"#ffeeff\" width=\"180\">\u79d2<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\" rowspan=\"2\">#2:18:07 AM#<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">&#8220;s&#8221;<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">7<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffeeff\" width=\"180\">\u79d2\uff081\u6841\u306e\u5834\u5408\u3001\u5148\u982d\u306b\u300c0\u300d\u304c\u4ed8\u304f\uff09<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">&#8220;ss&#8221;<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">07<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffeeff\" width=\"80\" align = \"center\" >t<\/td>\n<td bgcolor=\"#ffeeff\" width=\"180\">\u6642\u523b\uff08\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u30d1\u30cd\u30eb\u3067\u8a2d\u5b9a\uff09<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">#1\/1\/2015 12:11:00 PM#<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">&#8220;ttttt&#8221;<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">12:11:00<\/td>\n<tr>\n<td bgcolor=\"#ffeeff\" width=\"80\" align = \"center\" >c<\/td>\n<td bgcolor=\"#ffeeff\" width=\"180\">\u65e5\u4ed8\u6642\u523b\uff08\u65e5\u4ed8\u306e\u90e8\u5206\u306f\u3001\u300cddddd\u300d\u3068\u540c\u3058\u3001\u6642\u523b\u306e\u90e8\u5206\u306f\u300cttttt\u300d\u3068\u540c\u3058\uff09<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">#3\/3\/2015 12:11:00 PM#<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">&#8220;c&#8221;<\/td>\n<td bgcolor=\"#ffeeff\" width=\"100\" align = \"center\">2015\/03\/03 12:11:00<\/td>\n<\/tr>\n<\/table>\n<\/div>\n<br \/><br \/>\n<p id=\"Format_table2\" class=\"caution4\"><strong>\u5b9a\u7fa9\u6e08\u307f\u66f8\u5f0f<\/strong><\/p>\n<div class=\"m30-l\">\n<strong>\u6570\u5024\u66f8\u5f0f<\/strong><\/p>\n<table>\n<tr>\n<td align = \"center\" width=\"120\" bgcolor=\"#ffffcc\"><strong>\u66f8\u5f0f<\/strong><\/td>\n<td align = \"center\" width=\"480\" bgcolor=\"#ffffcc\"><strong>\u5185\u5bb9<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"120\">General Number<\/td>\n<td width=\"480\">\u6570\u5024\u3092 1000 \u5358\u4f4d\u306e\u533a\u5207\u308a\u8a18\u53f7\u306f\u4ed8\u3051\u306a\u3044\u3002<\/td>\n<\/tr>\n<tr>\n<td width=\"120\">Currency<\/td>\n<td width=\"480\">\u901a\u8ca8\u8a18\u53f7\u3001\u5c0f\u6570\u70b9\u4ee5\u4e0b\u306e\u6841\u6570\u30011000 \u5358\u4f4d\u306e\u533a\u5207\u308a\u8a18\u53f7\u3092\u4ed8\u3051\u308b\u3002<\/td>\n<\/tr>\n<tr>\n<td width=\"120\">Fixed<\/td>\n<td width=\"480\">\u6574\u6570\u90e8\u3092\u6700\u4f4e 1 \u6841\u3001\u5c0f\u6570\u90e8\u3092\u6700\u4f4e 2 \u6841\u8868\u793a\u30021000 \u5358\u4f4d\u306e\u533a\u5207\u308a\u8a18\u53f7\u306f\u4ed8\u3051\u306a\u3044\u3002<\/td>\n<\/tr>\n<tr>\n<td width=\"120\">Standard<\/td>\n<td width=\"480\">\u6574\u6570\u90e8\u3092\u6700\u4f4e 1 \u6841\u3001\u5c0f\u6570\u90e8\u3092\u6700\u4f4e 2 \u6841\u8868\u793a\u30021000 \u5358\u4f4d\u306e\u533a\u5207\u308a\u8a18\u53f7\u3092\u4ed8\u3051\u308b\u3002 <\/td>\n<\/tr>\n<tr>\n<td width=\"120\">Percent<\/td>\n<td width=\"480\">\u6307\u5b9a\u3057\u305f\u6570\u5024\u3092 100 \u500d\u3057\u3066\u3001\u5c0f\u6570\u90e8\u3092\u5e38\u306b 2 \u6841\u8868\u793a\u3002\u30d1\u30fc\u30bb\u30f3\u30c8\u8a18\u53f7\uff08%\uff09\u304c\u53f3\u5074\u306b\u4ed8\u304f\u3002 <\/td>\n<\/tr>\n<tr>\n<td width=\"120\">Scientific<\/td>\n<td width=\"480\">\u6a19\u6e96\u7684\u306a\u79d1\u5b66\u8868\u8a18\u6cd5\u3067\u8868\u3057\u305f\u6587\u5b57\u5217\u3092\u8fd4\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td width=\"120\">Yes\/No<\/td>\n<td width=\"480\">\u6570\u5024\u304c 0 \u306e\u5834\u5408\u306b\u306f No\u3001\u305d\u308c\u4ee5\u5916\u306f Yes \u3092\u8fd4\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td width=\"120\">True\/False<\/td>\n<td width=\"480\">\u6570\u5024\u304c 0 \u306e\u5834\u5408\u306b\u306f\u507d (False)\u3001\u305d\u308c\u4ee5\u5916\u306f\u771f (True) \u3092\u8fd4\u3059\u3002<\/td>\n<\/tr>\n<tr>\n<td width=\"120\">On\/Off<\/td>\n<td width=\"480\">\u6570\u5024\u304c 0 \u306e\u5834\u5408\u306b\u306f Off\u3001\u305d\u308c\u4ee5\u5916\u306f On \u3092\u8fd4\u3059\u3002<\/td>\n<\/tr>\n<\/table>\n<p><br \/><br \/>\n<strong>\u65e5\u4ed8\u30fb\u6642\u523b\u66f8\u5f0f<\/strong><\/p>\n<table>\n<tr>\n<td align = \"center\" width=\"120\" bgcolor=\"#ffffcc\"><strong>\u66f8\u5f0f<\/strong><\/td>\n<td align = \"center\" width=\"480\" bgcolor=\"#ffffcc\"><strong>\u5185\u5bb9<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"120\">General Date<\/td>\n<td width=\"480\">\u65e5\u4ed8\u307e\u305f\u306f\u6642\u523b\u3001\u3042\u308b\u3044\u306f\u305d\u306e\u4e21\u65b9\u3092\u8fd4\u3059\u3002\u65e5\u4ed8\u3068\u6642\u523b\u306e\u8868\u793a\u5f62\u5f0f\u306f\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb \u30d1\u30cd\u30eb\u306e\u8a2d\u5b9a\u3002<\/td>\n<\/tr>\n<tr>\n<td width=\"120\">Long Date<\/td>\n<td width=\"480\">\u5e74\u6708\u65e5\u3092\u542b\u3080\u9577\u3044\u5f62\u5f0f\uff08\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u30d1\u30cd\u30eb\u3067\u8a2d\u5b9a\uff09\u3067\u8868\u3057\u305f\u65e5\u4ed8\u3002<\/td>\n<\/tr>\n<tr>\n<td width=\"120\">Medium Date<\/td>\n<td width=\"480\">\u7c21\u7565\u5f62\u5f0f\u3067\u8868\u3057\u305f\u65e5\u4ed8\u3002<\/td>\n<\/tr>\n<tr>\n<td width=\"120\">Short Date<\/td>\n<td width=\"480\">\u5e74\u6708\u65e5\u3092\u542b\u3080\u77ed\u3044\u5f62\u5f0f\uff08\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u30d1\u30cd\u30eb\u3067\u8a2d\u5b9a\uff09\u3067\u8868\u3057\u305f\u65e5\u4ed8\u3002<\/td>\n<\/tr>\n<tr>\n<td width=\"120\">Long Time<\/td>\n<td width=\"480\">\u6642\u523b\u3001\u5206\u3001\u79d2\u3092\u542b\u3080\u5f62\u5f0f\u3067\u8868\u3057\u305f\u6642\u523b\u3002<\/td>\n<\/tr>\n<tr>\n<td width=\"120\">Medium Time<\/td>\n<td width=\"480\">\u6642\u9593\u3068\u5206\u3092 12 \u6642\u9593\u5236\u3067\u8868\u3057\u305f\u6642\u523b\u3002\u5348\u524d\u306f\u300cAM\u300d\u3001\u5348\u5f8c\u306f\u300cPM\u300d\u3092\u4ed8\u3051\u308b\u3002<\/td>\n<\/tr>\n<tr>\n<td width=\"120\">Short Time<\/td>\n<td width=\"480\">\u6642\u9593\u3068\u5206\u3092 24 \u6642\u9593\u5236\u3067\u8868\u3057\u305f\u6642\u523b\u3002<\/td>\n<\/tr>\n<\/table>\n<\/div>\n<br \/><br \/>\n<p id=\"format_firstdayofweek\" class=\"caution4\"><strong>\u9031\u306e\u59cb\u307e\u308a\u306e\u66dc\u65e5\u3092\u793a\u3059\u5b9a\u6570\uff08<em>firstdayofweek<\/em> \u306b\u6307\u5b9a\u3059\u308b\u5024\uff09<\/strong><\/p>\n<div class=\"m30-l\">\n<table>\n<tr>\n<td align = \"center\" width=\"100\" bgcolor=\"#ffffcc\"><strong>\u5024<\/strong><\/td>\n<td align = \"center\" width=\"150\" bgcolor=\"#ffffcc\"><strong>\u5b9a\u6570<\/strong><\/td>\n<td align = \"center\" width=\"300\" bgcolor=\"#ffffcc\"><strong>\u5185\u5bb9<\/strong><\/td>\n<\/tr>\n<tr>\n<td align = \"center\">0<\/td>\n<td>vbUseSystem<\/td>\n<td>NLS\uff08\u30b7\u30b9\u30c6\u30e0\u306e\u5404\u56fd\u5bfe\u5fdc\uff09API\u306e\u8a2d\u5b9a\u5024\u3092\u4f7f\u7528<\/td>\n<\/tr>\n<tr>\n<td align = \"center\">1<\/td>\n<td>vbSunday<\/td>\n<td>\u65e5\u66dc\u65e5\uff08\u898f\u5b9a\u5024\uff09<\/td>\n<\/tr>\n<tr>\n<td align = \"center\">2<\/td>\n<td>vbMonday<\/td>\n<td>\u6708\u66dc\u65e5<\/td>\n<\/tr>\n<tr>\n<td align = \"center\">3<\/td>\n<td>vbTuesday<\/td>\n<td>\u706b\u66dc\u65e5<\/td>\n<\/tr>\n<tr>\n<td align = \"center\">4<\/td>\n<td>vbWednesday<\/td>\n<td>\u6c34\u66dc\u65e5<\/td>\n<\/tr>\n<tr>\n<td align = \"center\">5<\/td>\n<td>vbThursday<\/td>\n<td>\u6728\u66dc\u65e5<\/td>\n<\/tr>\n<tr>\n<td align = \"center\">6<\/td>\n<td>vbFriday<\/td>\n<td>\u91d1\u66dc\u65e5<\/td>\n<\/tr>\n<tr>\n<td align = \"center\">7<\/td>\n<td>vbSaturday<\/td>\n<td>\u571f\u66dc\u65e5<\/td>\n<\/tr>\n<\/table>\n<\/div>\n<br \/><br \/>\n<p id=\"format_firstweekofyear\" class=\"caution4\"><strong>\u5e74\u5ea6\u306e\u59cb\u307e\u308a\u3092\u793a\u3059\u5b9a\u6570\uff08<em>firstweekofyear<\/em> \u306b\u6307\u5b9a\u3059\u308b\u5024\uff09<\/strong><\/p>\n<div class=\"m30-l\">\n<table>\n<tr>\n<td align = \"center\" width=\"100\" bgcolor=\"#ffffcc\"><strong>\u5024<\/strong><\/td>\n<td align = \"center\" width=\"150\" bgcolor=\"#ffffcc\"><strong>\u5b9a\u6570<\/strong><\/td>\n<td align = \"center\" width=\"300\" bgcolor=\"#ffffcc\"><strong>\u5185\u5bb9<\/strong><\/td>\n<\/tr>\n<tr>\n<td align = \"center\" width=\"100\">0<\/td>\n<td width=\"150\">vbUseSystem<\/td>\n<td width=\"300\">NLS\uff08\u30b7\u30b9\u30c6\u30e0\u306e\u5404\u56fd\u5bfe\u5fdc\uff09API\u306e\u8a2d\u5b9a\u5024\u3092\u4f7f\u7528<\/td>\n<\/tr>\n<tr>\n<td align = \"center\" width=\"100\">1<\/td>\n<td width=\"150\">vbFirstJan1<\/td>\n<td width=\"300\">1\u67081\u65e5\u3092\u542b\u3080\u9031\u3092\u5e74\u5ea6\u306e\u7b2c1\u9031\u3068\u3059\u308b\uff08\u898f\u5b9a\u5024\uff09<\/td>\n<\/tr>\n<tr>\n<td align = \"center\" width=\"100\">2<\/td>\n<td width=\"150\">vbFirstFourDays<\/td>\n<td width=\"300\">7\u65e5\u306e\u3046\u3061\u5c11\u306a\u304f\u3068\u30824\u65e5\u304c\u65b0\u5e74\u5ea6\u306b\u542b\u307e\u308c\u308b\u9031\u3092\u5e74\u5ea6\u306e\u7b2c1\u9031\u3068\u3059\u308b<\/td>\n<\/tr>\n<tr>\n<td align = \"center\" width=\"100\">3<\/td>\n<td width=\"150\">vbFirstFullWeek<\/td>\n<td width=\"300\">\u5168\u4f53\u304c\u65b0\u5e74\u5ea6\u306b\u542b\u307e\u308c\u308b\u6700\u521d\u306e\u9031\u3092\u5e74\u5ea6\u306e\u7b2c1\u9031\u3068\u3059\u308b<\/td>\n<\/tr>\n<\/table>\n<\/div>\n<\/div>\n<br \/><br \/><br \/>\n<h2>Format \u95a2\u6570\u306e\u4f7f\u7528\u4f8b\uff08\uff11\uff09<\/h2>\n<div class=\"m30-l\">\n<h3 id=\"vba_sample\">\u6570\u5024\u30fb\u6587\u5b57\u5217 \u8868\u793a\u66f8\u5f0f\u6307\u5b9a\u6587\u5b57<\/h3>\n<pre class=\"lang:vb mark:0 decode:true \" title=\"Format \u95a2\u6570\u306e\u4f7f\u7528\u4f8b\uff08\uff11\uff09\" data-url=\"http:\/\/example.co.jp\" >\r\n\u3000\r\nSub SampleFormat01()\r\n\r\n    'Format \u95a2\u6570\u4f7f\u7528\u4f8b\u305d\u306e\uff11\r\n\r\n    Debug.Print Format(125.25)\r\n    Debug.Print Format(125.25, \"0000.0\")\r\n    Debug.Print Format(125.25, \"0.000\")\r\n    Debug.Print Format(125.25, \"####.#\")\r\n    Debug.Print Format(125.25, \"#.###\")\r\n    Debug.Print Format(0.365, \"#.#0%\")\r\n    Debug.Print Format(1259900, \"#,#\")\r\n    Debug.Print Format(1259900, \"#,#,\u5343\u5186\")\r\n    Debug.Print Format(1259900, \"0,0\")\r\n    Debug.Print Format(100000000, \"0.00e+\")\r\n    Debug.Print Format(-100000000, \"0.00e+\")\r\n    Debug.Print Format(0.5, \"0.00e+\")\r\n    Debug.Print Format(2500, \"0.00e-\")\r\n    Debug.Print Format(-100000000, \"0.00e-\")\r\n    Debug.Print Format(0.5, \"0.00e-\")\r\n    Debug.Print Format(1000, \"\\\\#,#\")\r\n    Debug.Print Format(\"1\", \"@@\u6708\")\r\n    Debug.Print Format(\"1\", \"&&\u6708\")\r\n    Debug.Print Format(\"ABCDE\", \"<\")\r\n    Debug.Print Format(\"abcde\", \">\")\r\n    Debug.Print Format(\"abcde\", \"@@!\")\r\n    \r\nEnd Sub\r\n\u3000\r\n<\/pre>\n<br \/>\n<h3>\u5b9f\u884c\u7d50\u679c<\/h3>\n<p><a href=\"https:\/\/i2.wp.com\/excelwork.info\/excel\/wp\/wp-content\/uploads\/2015\/04\/format01.jpg?ssl=1\" rel=\"lightbox[1505]\"><img loading=\"lazy\" src=\"https:\/\/i2.wp.com\/excelwork.info\/excel\/wp\/wp-content\/uploads\/2015\/04\/format01.jpg?resize=400%2C209&#038;ssl=1\" alt=\"Format \u95a2\u6570\u3000\u4f8b1\" width=\"400\" height=\"209\" class=\"alignnone size-medium wp-image-1528\" srcset=\"https:\/\/i2.wp.com\/excelwork.info\/excel\/wp\/wp-content\/uploads\/2015\/04\/format01.jpg?resize=400%2C209&amp;ssl=1 400w, https:\/\/i2.wp.com\/excelwork.info\/excel\/wp\/wp-content\/uploads\/2015\/04\/format01.jpg?resize=580%2C304&amp;ssl=1 580w, https:\/\/i2.wp.com\/excelwork.info\/excel\/wp\/wp-content\/uploads\/2015\/04\/format01.jpg?w=699&amp;ssl=1 699w\" sizes=\"(max-width: 400px) 100vw, 400px\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<br \/><\/div>\n<br \/><br \/>\n<h2>Format \u95a2\u6570\u306e\u4f7f\u7528\u4f8b\uff08\uff12\uff09<\/h2>\n<div class=\"m30-l\">\n<h3 id=\"vba_sample\">\u65e5\u4ed8\u30fb\u6642\u523b \u8868\u793a\u66f8\u5f0f\u6307\u5b9a\u6587\u5b57<\/h3>\n<pre class=\"lang:vb mark:0 decode:true \" title=\"Format \u95a2\u6570\u306e\u4f7f\u7528\u4f8b\uff08\uff12\uff09\" data-url=\"http:\/\/example.co.jp\" >\r\n\u3000\r\nSub SampleFormat02()\r\n\r\n    'Format \u95a2\u6570\u4f7f\u7528\u4f8b\u305d\u306e\uff12\r\n\r\n    Debug.Print Format(#1\/1\/2015#, \"y\")\r\n    Debug.Print Format(#1\/1\/2015#, \"yy\")\r\n    Debug.Print Format(#1\/1\/2015#, \"yyyy\")\r\n    Debug.Print Format(#1\/1\/2015#, \"m\")\r\n    Debug.Print Format(#1\/1\/2015#, \"mm\")\r\n    Debug.Print Format(#1\/1\/2015#, \"mmm\")\r\n    Debug.Print Format(#1\/1\/2015#, \"mmmm\")\r\n    Debug.Print Format(#1\/1\/2015#, \"oooo\")\r\n    Debug.Print Format(#1\/1\/2015#, \"d\")\r\n    Debug.Print Format(#1\/1\/2015#, \"dd\")\r\n    Debug.Print Format(#1\/1\/2015#, \"ddd\")\r\n    Debug.Print Format(#1\/1\/2015#, \"dddd\")\r\n    Debug.Print Format(#1\/1\/2015#, \"ddddd\")\r\n    Debug.Print Format(#1\/1\/2015#, \"dddddd\")\r\n    Debug.Print Format(#1\/1\/2015#, \"aaa\")\r\n    Debug.Print Format(#1\/1\/2015#, \"aaaa\")\r\n    Debug.Print Format(#1\/1\/2015#, \"w\")\r\n    Debug.Print Format(#1\/1\/2015#, \"ww\")\r\n    Debug.Print Format(#1\/1\/2015#, \"g\")\r\n    Debug.Print Format(#1\/1\/2015#, \"gg\")\r\n    Debug.Print Format(#1\/1\/2015#, \"ggg\")\r\n    Debug.Print Format(#1\/1\/2015#, \"e\")\r\n    Debug.Print Format(#1\/1\/2015#, \"ee\")\r\n    Debug.Print Format(#1:11:00 AM#, \"h\")\r\n    Debug.Print Format(#1:11:00 AM#, \"hh\")\r\n    Debug.Print Format(#1:11:00 AM#, \"n\")\r\n    Debug.Print Format(#1:11:00 AM#, \"nn\")\r\n    Debug.Print Format(#2:18:07 AM#, \"s\")\r\n    Debug.Print Format(#2:18:07 AM#, \"ss\")\r\n    Debug.Print Format(#1\/1\/2015 12:11:00 PM#, \"ttttt\")\r\n    Debug.Print Format(#3\/3\/2015 12:11:00 PM#, \"c\")\r\n    \r\nEnd Sub\r\n\u3000\r\n<\/pre>\n<br \/>\n<h3>\u5b9f\u884c\u7d50\u679c<\/h3>\n<p><a href=\"https:\/\/i1.wp.com\/excelwork.info\/excel\/wp\/wp-content\/uploads\/2015\/04\/format02.jpg?ssl=1\" rel=\"lightbox[1505]\"><img loading=\"lazy\" src=\"https:\/\/i1.wp.com\/excelwork.info\/excel\/wp\/wp-content\/uploads\/2015\/04\/format02.jpg?resize=400%2C278&#038;ssl=1\" alt=\"Format \u95a2\u6570\u3000\u4f8b2\" width=\"400\" height=\"278\" class=\"alignnone size-medium wp-image-1529\" srcset=\"https:\/\/i1.wp.com\/excelwork.info\/excel\/wp\/wp-content\/uploads\/2015\/04\/format02.jpg?resize=400%2C278&amp;ssl=1 400w, https:\/\/i1.wp.com\/excelwork.info\/excel\/wp\/wp-content\/uploads\/2015\/04\/format02.jpg?resize=580%2C403&amp;ssl=1 580w, https:\/\/i1.wp.com\/excelwork.info\/excel\/wp\/wp-content\/uploads\/2015\/04\/format02.jpg?w=715&amp;ssl=1 715w\" sizes=\"(max-width: 400px) 100vw, 400px\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<br \/><\/div>\n<br \/><br \/>\n<h2>Format \u95a2\u6570\u306e\u4f7f\u7528\u4f8b\uff08\uff13\uff09<\/h2>\n<div class=\"m30-l\">\n<h3 id=\"vba_sample\">\u5b9a\u7fa9\u6e08\u307f\u66f8\u5f0f<\/h3>\n<pre class=\"lang:vb mark:0 decode:true \" title=\"Format \u95a2\u6570\u306e\u4f7f\u7528\u4f8b\uff08\uff13\uff09\" data-url=\"http:\/\/example.co.jp\" >\r\n\u3000\r\nSub SampleFormat03()\r\n\r\n    'Format \u95a2\u6570\u4f7f\u7528\u4f8b\u305d\u306e\uff13\r\n\r\n    \r\n    '\u5b9a\u7fa9\u6e08\u307f\u65e5\u4ed8\/\u6642\u523b\u66f8\u5f0f\r\n    \r\n    Debug.Print Format(#9\/8\/2015 3:21:09 AM#, \"General Date\")\r\n    Debug.Print Format(#9\/8\/2015 3:21:09 AM#, \"Long Date\")\r\n    Debug.Print Format(#9\/8\/2015 3:21:09 AM#, \"Medium Date\")\r\n    Debug.Print Format(#9\/8\/2015 3:21:09 AM#, \"Short Date\")\r\n    Debug.Print Format(#9\/8\/2015 3:21:09 AM#, \"Long Time\")\r\n    Debug.Print Format(#9\/8\/2015 3:21:09 AM#, \"Medium Time\")\r\n    Debug.Print Format(#9\/8\/2015 3:21:09 AM#, \"Short Time\")\r\n\r\n    Debug.Print\r\n    \r\n    '\u5b9a\u7fa9\u6e08\u307f\u6570\u5024\u66f8\u5f0f\r\n    \r\n    Debug.Print Format(7550.1268, \"General Number\")\r\n    Debug.Print Format(7550.1268, \"Currency\")\r\n    Debug.Print Format(7550.1268, \"Fixed\")\r\n    Debug.Print Format(7550.1268, \"Standard\")\r\n    Debug.Print Format(7550.1268, \"Percent\")\r\n    Debug.Print Format(7550.1268, \"Scientific\")\r\n    Debug.Print Format(7550.1268, \"Yes\/No\")\r\n    Debug.Print Format(7550.1268, \"True\/False\")\r\n    Debug.Print Format(7550.1268, \"On\/Off\")\r\n\r\n\r\nEnd Sub\r\n\u3000\r\n<\/pre>\n<br \/>\n<h3>\u5b9f\u884c\u7d50\u679c<\/h3>\n<p><a href=\"https:\/\/i0.wp.com\/excelwork.info\/excel\/wp\/wp-content\/uploads\/2015\/04\/format03.jpg?ssl=1\" rel=\"lightbox[1505]\"><img loading=\"lazy\" src=\"https:\/\/i0.wp.com\/excelwork.info\/excel\/wp\/wp-content\/uploads\/2015\/04\/format03.jpg?resize=400%2C223&#038;ssl=1\" alt=\"Format \u95a2\u6570\u3000\u4f8b3\" width=\"400\" height=\"223\" class=\"alignnone size-medium wp-image-1530\" srcset=\"https:\/\/i0.wp.com\/excelwork.info\/excel\/wp\/wp-content\/uploads\/2015\/04\/format03.jpg?resize=400%2C223&amp;ssl=1 400w, https:\/\/i0.wp.com\/excelwork.info\/excel\/wp\/wp-content\/uploads\/2015\/04\/format03.jpg?resize=580%2C323&amp;ssl=1 580w, https:\/\/i0.wp.com\/excelwork.info\/excel\/wp\/wp-content\/uploads\/2015\/04\/format03.jpg?w=755&amp;ssl=1 755w\" sizes=\"(max-width: 400px) 100vw, 400px\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<br \/><\/div>\n<br \/><br \/>\n<h2>Format \u95a2\u6570\u306e\u4f7f\u7528\u4f8b\uff08\uff14\uff09<\/h2>\n<div class=\"m30-l\">\n<h3 id=\"vba_sample\">\u8907\u6570\u306e\u66f8\u5f0f\u3092\u8a2d\u5b9a<\/h3>\n<pre class=\"lang:vb mark:0 decode:true \" title=\"Format \u95a2\u6570\u306e\u4f7f\u7528\u4f8b\uff08\uff14\uff09\" data-url=\"http:\/\/example.co.jp\" >\r\n\u3000\r\nSub SampleFormat04()\r\n\r\n    'Format \u95a2\u6570\u4f7f\u7528\u4f8b\u305d\u306e\uff14\r\n    \r\n\r\n    '\u8907\u6570\u306e\u66f8\u5f0f\u3092\u8a2d\u5b9a\u3059\u308b1\r\n    Debug.Print Format(39800, \"\\\\#,##0;(#,##0);#\")      '\u6b63\u6570\uff1a1\u756a\u76ee\u306e\u66f8\u5f0f\u9069\u7528\r\n    Debug.Print Format(-39800, \"\\\\#,##0;(#,##0);#\")     '\u8ca0\u6570\uff1a2\u756a\u76ee\u306e\u66f8\u5f0f\u9069\u7528\r\n    Debug.Print Format(0, \"\\\\#,##0;(#,##0);0\")          '0\uff1a3\u756a\u76ee\u306e\u66f8\u5f0f\u9069\u7528\r\n    \r\n    \r\n    '\u8907\u6570\u306e\u66f8\u5f0f\u3092\u8a2d\u5b9a\u3059\u308b2\uff082\u756a\u76ee\u306e\u66f8\u5f0f\u3092\u8a2d\u5b9a\u3057\u3066\u3044\u306a\u3044\uff09\r\n    Debug.Print Format(25, \"0000;;#;\\N\\U\\L\\L\")          '\u6b63\u6570\uff1a1\u756a\u76ee\u306e\u66f8\u5f0f\u9069\u7528\r\n    Debug.Print Format(-25, \"0000;;#;\\N\\U\\L\\L\")         '\u8ca0\u6570\uff1a1\u756a\u76ee\u306e\u66f8\u5f0f\u9069\u7528\r\n    Debug.Print Format(0, \"0000;;#;\\N\\U\\L\\L\")           '0\uff1a3\u756a\u76ee\u306e\u66f8\u5f0f\u9069\u7528\r\n    Debug.Print Format(Null, \"0000;;#;\\N\\U\\L\\L\")        'Null\uff1a4\u756a\u76ee\u306e\u66f8\u5f0f\u9069\u7528\r\n    \r\nEnd Sub\r\n\r\n\u3000\r\n<\/pre>\n<br \/>\n<h3>\u5b9f\u884c\u7d50\u679c<\/h3>\n<p><a href=\"https:\/\/i1.wp.com\/excelwork.info\/excel\/wp\/wp-content\/uploads\/2015\/04\/format04.jpg?ssl=1\" rel=\"lightbox[1505]\"><img loading=\"lazy\" src=\"https:\/\/i1.wp.com\/excelwork.info\/excel\/wp\/wp-content\/uploads\/2015\/04\/format04.jpg?resize=400%2C124&#038;ssl=1\" alt=\"Format \u95a2\u6570\u3000\u4f8b4\" width=\"400\" height=\"124\" class=\"alignnone size-medium wp-image-1531\" srcset=\"https:\/\/i1.wp.com\/excelwork.info\/excel\/wp\/wp-content\/uploads\/2015\/04\/format04.jpg?resize=400%2C124&amp;ssl=1 400w, https:\/\/i1.wp.com\/excelwork.info\/excel\/wp\/wp-content\/uploads\/2015\/04\/format04.jpg?resize=580%2C179&amp;ssl=1 580w, https:\/\/i1.wp.com\/excelwork.info\/excel\/wp\/wp-content\/uploads\/2015\/04\/format04.jpg?w=896&amp;ssl=1 896w\" sizes=\"(max-width: 400px) 100vw, 400px\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<br \/><\/div>\n<br \/><br \/>\n","protected":false},"excerpt":{"rendered":"<p>Format \u95a2\u6570\u306e\u4f7f\u3044\u65b9 \u3010\u66f8\u5f0f\u3011 result = Format ( exp &#8230; <\/p>\n","protected":false},"author":1,"featured_media":1535,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"amp_status":"","spay_email":"","jetpack_publicize_message":""},"categories":[37],"tags":[146,63,38,147],"jetpack_featured_media_url":"https:\/\/i1.wp.com\/excelwork.info\/excel\/wp\/wp-content\/uploads\/2015\/04\/format01-400x2091.jpg?fit=400%2C209&ssl=1","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/s4Ye9i-format","_links":{"self":[{"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/posts\/1505"}],"collection":[{"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/comments?post=1505"}],"version-history":[{"count":30,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/posts\/1505\/revisions"}],"predecessor-version":[{"id":4774,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/posts\/1505\/revisions\/4774"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/media\/1535"}],"wp:attachment":[{"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/media?parent=1505"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/categories?post=1505"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/tags?post=1505"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}