<p><img data-attachment-id="7820" data-permalink="https://www.eskyjapan.com/memo/excel_ge/attachment/062341ba755855225e949d97aabe95e1_s/" data-orig-file="https://i0.wp.com/www.eskyjapan.com/wp-content/uploads/2019/01/062341ba755855225e949d97aabe95e1_s.jpg?fit=640%2C427&;ssl=1" data-orig-size="640,427" data-comments-opened="0" data-image-meta="{";aperture";:";0";,";credit";:";";,";camera";:";";,";caption";:";";,";created_timestamp";:";0";,";copyright";:";";,";focal_length";:";0";,";iso";:";0";,";shutter_speed";:";0";,";title";:";";,";orientation";:";0";}" data-image-title="062341ba755855225e949d97aabe95e1_s" data-image-description="" data-image-caption="" data-medium-file="https://i0.wp.com/www.eskyjapan.com/wp-content/uploads/2019/01/062341ba755855225e949d97aabe95e1_s.jpg?fit=300%2C200&;ssl=1" data-large-file="https://i0.wp.com/www.eskyjapan.com/wp-content/uploads/2019/01/062341ba755855225e949d97aabe95e1_s.jpg?fit=637%2C425&;ssl=1" class="aligncenter size-full wp-image-7820" src="https://www.eskyjapan.com/wp-content/uploads/2019/01/062341ba755855225e949d97aabe95e1_s.jpg" alt="" width="640" height="427" /><br />

<!-- WP QUADS Content Ad Plugin v. 2.0.99 -->
<div class="quads-location quads-ad1" id="quads-ad1" style="float:none;margin:0px;">

</div>
</p>
<p>2019å¹´4æ1æ¥ã«æ°å å·ãçºè¡¨ããã¾ãã<br />
åãæ¿ãã®æ¥ç¨ã¯2019å¹´5æ1æ¥ã¨æ±ºå®ãã¦ãã¾ãã<br />
2019å¹´1æã«æ°å å·ã®æºåã¨ããã¢ãããã¼ããé ä¿¡ããã¾ããã<br />
Excel 2010ã§ã¯ããã®æºå段éã®ã¢ãããã¼ãã«ããä¸å ·åãçºçãã¦ããã®ã§ãExcelã®ã¢ãããã¼ãã¯ãã°ããå¾ ã£ãã»ããè¯ãããã§ãã<br />
ããã¦ããããããã¤ã¯ãã½ãã社ã1æããã°æ°å å·ã«å¯¾å¿ãã¦ããã¨ã¯æãã¾ããããããéã«åããªãã£ãã大å¤ã<br />
ããã«ããã¤ã¯ãã½ãããæ°å å·ã«å¯¾å¿ããã¨ãã¦ããå å¹´ã1å¹´ã¨è¡¨ç¤ºãããã¯ãã ã･･･<br />
ããã§ã2019å¹´5æ1æ¥ï½2019å¹´12æ31æ¥ã¾ã§ã®éã ãã®æ«å®å¯¾çãè¨è¼ãã¦ããã¾ãã<br />
å å¹´ã¨è¡¨ç¤ºãããããªãã絶対ã«ããããã<br />
ãããè¨å®ãã¦ãã°ãä¸å ·åã®çºçããã¢ãããã¼ããããã¦ã2020å¹´ã¾ã§èãããã¨ãã§ãã¾ãã<br />
2020å¹´ã«ãªãã°ããã°ã®ãªãã¢ãããã¼ããæå¾ ã§ããã®ã§ãããã¾ã§ã®æ«å®å¦ç½®ã¨ãã¦åèã«ãã¦ã¿ã¦ãã ããã</p>
<h3 class="style3b">ã·ãªã¢ã«å¤ã®ç¢ºèª</h3>
<p>ã·ãªã¢ã«å¤ã£ã¦ãªãã ï¼ã¨æã人ãããããããã¾ããããç解ããããæ £ãã¦ããã¾ãããã<br />
ã·ãªã¢ã«å¤ã¯å¾ã»ã©èª¬æãã¾ãã<br />
Excelã§æ¬¡ã®ããã«å ¥åãã¦ã¿ã¦ãã ããã<br />
<img data-attachment-id="7812" data-permalink="https://www.eskyjapan.com/memo/excel_ge/attachment/20190501_1/" data-orig-file="https://i0.wp.com/www.eskyjapan.com/wp-content/uploads/2019/01/20190501_1.jpg?fit=197%2C84&;ssl=1" data-orig-size="197,84" data-comments-opened="0" data-image-meta="{";aperture";:";0";,";credit";:";eiji";,";camera";:";";,";caption";:";";,";created_timestamp";:";0";,";copyright";:";";,";focal_length";:";0";,";iso";:";0";,";shutter_speed";:";0";,";title";:";";,";orientation";:";0";}" data-image-title="20190501_1" data-image-description="" data-image-caption="" data-medium-file="https://i0.wp.com/www.eskyjapan.com/wp-content/uploads/2019/01/20190501_1.jpg?fit=197%2C84&;ssl=1" data-large-file="https://i0.wp.com/www.eskyjapan.com/wp-content/uploads/2019/01/20190501_1.jpg?fit=197%2C84&;ssl=1" class="aligncenter size-full wp-image-7812" src="https://www.eskyjapan.com/wp-content/uploads/2019/01/20190501_1.jpg" alt="" width="197" height="84" /><br />
å ¥åããã»ã«ï¼B2:B3ï¼ãé¸æããå³ã¯ãªãã¯<br />
<img data-attachment-id="7813" data-permalink="https://www.eskyjapan.com/memo/excel_ge/attachment/20190501_2/" data-orig-file="https://i0.wp.com/www.eskyjapan.com/wp-content/uploads/2019/01/20190501_2.jpg?fit=405%2C440&;ssl=1" data-orig-size="405,440" data-comments-opened="0" data-image-meta="{";aperture";:";0";,";credit";:";";,";camera";:";";,";caption";:";";,";created_timestamp";:";0";,";copyright";:";";,";focal_length";:";0";,";iso";:";0";,";shutter_speed";:";0";,";title";:";";,";orientation";:";0";}" data-image-title="20190501_2" data-image-description="" data-image-caption="" data-medium-file="https://i0.wp.com/www.eskyjapan.com/wp-content/uploads/2019/01/20190501_2.jpg?fit=276%2C300&;ssl=1" data-large-file="https://i0.wp.com/www.eskyjapan.com/wp-content/uploads/2019/01/20190501_2.jpg?fit=391%2C425&;ssl=1" class="aligncenter size-full wp-image-7813" src="https://www.eskyjapan.com/wp-content/uploads/2019/01/20190501_2.jpg" alt="" width="405" height="440" /><br />
ãã®ã¾ã¾ãã»ã«ã®æ¸å¼è¨å®ããã¯ãªãã¯<br />
<img data-attachment-id="7814" data-permalink="https://www.eskyjapan.com/memo/excel_ge/attachment/20190501_3/" data-orig-file="https://i0.wp.com/www.eskyjapan.com/wp-content/uploads/2019/01/20190501_3.jpg?fit=502%2C372&;ssl=1" data-orig-size="502,372" data-comments-opened="0" data-image-meta="{";aperture";:";0";,";credit";:";eiji";,";camera";:";";,";caption";:";";,";created_timestamp";:";1546899422";,";copyright";:";";,";focal_length";:";0";,";iso";:";0";,";shutter_speed";:";0";,";title";:";";,";orientation";:";0";}" data-image-title="20190501_3" data-image-description="" data-image-caption="" data-medium-file="https://i0.wp.com/www.eskyjapan.com/wp-content/uploads/2019/01/20190501_3.jpg?fit=300%2C222&;ssl=1" data-large-file="https://i0.wp.com/www.eskyjapan.com/wp-content/uploads/2019/01/20190501_3.jpg?fit=502%2C372&;ssl=1" class="aligncenter size-full wp-image-7814" src="https://www.eskyjapan.com/wp-content/uploads/2019/01/20190501_3.jpg" alt="" width="502" height="372" /><br />
ããã¨ããã§ã«Excelã¯æ¥ä»ã ã¨èªèãã¦ããã®ã§ããã®ããã«ãªã£ã¦ãã¾ãã<br />
ãããæ¨æºã«å¤æ´ãã¾ãã<br />
<img data-attachment-id="7816" data-permalink="https://www.eskyjapan.com/memo/excel_ge/attachment/20190501_4/" data-orig-file="https://i0.wp.com/www.eskyjapan.com/wp-content/uploads/2019/01/20190501_4.jpg?fit=507%2C272&;ssl=1" data-orig-size="507,272" data-comments-opened="0" data-image-meta="{";aperture";:";0";,";credit";:";eiji";,";camera";:";";,";caption";:";";,";created_timestamp";:";1546899460";,";copyright";:";";,";focal_length";:";0";,";iso";:";0";,";shutter_speed";:";0";,";title";:";";,";orientation";:";0";}" data-image-title="20190501_4" data-image-description="" data-image-caption="" data-medium-file="https://i0.wp.com/www.eskyjapan.com/wp-content/uploads/2019/01/20190501_4.jpg?fit=300%2C161&;ssl=1" data-large-file="https://i0.wp.com/www.eskyjapan.com/wp-content/uploads/2019/01/20190501_4.jpg?fit=507%2C272&;ssl=1" class="aligncenter size-full wp-image-7816" src="https://www.eskyjapan.com/wp-content/uploads/2019/01/20190501_4.jpg" alt="" width="507" height="272" /><br />
次ã«ãOKããæ¼ãã¦ã¿ãã¨ããã®ãããªè¡¨ç¤ºã«å¤ãã£ã¦ãã¾ãã<br />
<img data-attachment-id="7815" data-permalink="https://www.eskyjapan.com/memo/excel_ge/attachment/20190501_5/" data-orig-file="https://i0.wp.com/www.eskyjapan.com/wp-content/uploads/2019/01/20190501_5.jpg?fit=194%2C86&;ssl=1" data-orig-size="194,86" data-comments-opened="0" data-image-meta="{";aperture";:";0";,";credit";:";eiji";,";camera";:";";,";caption";:";";,";created_timestamp";:";1546899498";,";copyright";:";";,";focal_length";:";0";,";iso";:";0";,";shutter_speed";:";0";,";title";:";";,";orientation";:";0";}" data-image-title="20190501_5" data-image-description="" data-image-caption="" data-medium-file="https://i0.wp.com/www.eskyjapan.com/wp-content/uploads/2019/01/20190501_5.jpg?fit=194%2C86&;ssl=1" data-large-file="https://i0.wp.com/www.eskyjapan.com/wp-content/uploads/2019/01/20190501_5.jpg?fit=194%2C86&;ssl=1" class="aligncenter size-full wp-image-7815" src="https://www.eskyjapan.com/wp-content/uploads/2019/01/20190501_5.jpg" alt="" width="194" height="86" /><br />
ããããã·ãªã¢ã«å¤ã§ãã<br />
2019/4/30 → 43585<br />
2019/5/1 → 43586<br />
ã»ã¨ãã©ã®Excelã§ã¯ãããã¨åã表示ã«ãªã£ã¦ãã¾ãããä¸ã«ã¯éãçªå·ã表示ããããã¨ãããã®ã§ãå¿ ã確èªãã¦ãã ããã</p>
<h4 class="style4a">ã·ãªã¢ã«å¤ã¨ã¯</h4>
<p>1900å¹´1æ1æ¥ãã1ãã¨ãã¦å®ãã¦ããæ°åã®ãã¨ã§ãã<br />
ãã¾ã«ããããå¹´ãèæ ®ãã¦ã190<span style="font-size: 18pt;"><strong>4</strong></span>å¹´1æ1æ¥ãã1ãã¨ãã¦å®ãã¦ããExcelãããã¾ãã<br />
ããã¯ãããã°ã©ã çãªãã¨ãèæ ®ãã¦ããã®ã§ããããã¾ãæ·±ãèããªãã¦ã大ä¸å¤«ã§ãã</p>
<h3 class="style3b">表示形å¼ã®ä½æ</h3>
<p>2019å¹´5æ1æ¥ã®ã·ãªã¢ã«å¤ãã43586ãã¨ç¢ºèªã§ãã¾ããã<br />
åãããã«2020å¹´1æ1æ¥ã確èªããã¨ã43831ãã¨ãããã¾ãã<br />
ãããå©ç¨ãã¦è¡¨ç¤ºå½¢å¼ãä½æãã¦ããã¾ãã<br />
ãã¾ãç¥ããã¦ããªãã®ã§ããã表示形å¼ã«ãæ¡ä»¶ãä»ããäºãã§ãã¾ãï¼<br />
<strong><span style="color: #ff0000;">ã43586ããããå°ãããã°ãä»ã¾ã§éãã®å å·è¡¨ç¤ºï¼å¹³æ←æå←大æ£ï½¥ï½¥ï½¥ï¼ã</span></strong><br />
<strong><span style="color: #0000ff;">ã43831ããããå°ãããã°ãæ°å å·è¡¨ç¤ºã</span></strong><br />
<strong><span style="color: #ff6600;">ãã以å¤ã¯ãä»ã¾ã§éãã®å å·è¡¨ç¤ºã</span></strong><br />
ãã®è¡¨ä»¶ã表ãããã®ãããã<br />
<strong><span style="color: #ff0000;">[<;43586]ggge&#8221;å¹´&#8221;m&#8221;æ&#8221;d&#8221;æ¥&#8221;</span></strong>;<strong><span style="color: #0000ff;">[<;43831]&#8221;æ°å å·1å¹´&#8221;m&#8221;æ&#8221;d&#8221;æ¥&#8221;</span></strong>;<strong><span style="color: #ff6600;">ggge&#8221;å¹´&#8221;m&#8221;æ&#8221;d&#8221;æ¥&#8221;</span></strong><br />
å ã»ã©ã®è¦é ã§ãé¸æï¼ä»åã¯C2:C5ï¼ãã¦ãã»ã«ã®æ¸å¼è¨å®ããéããã¦ã¼ã¶ã¼å®ç¾©ãé¸æãã¾ãã<br />
<span style="color: #000000;">ã¦ã£ã³ãã¦ä¸å¤®è¾ºãã«ã種é¡(T)ããããã¨æãã¾ããããã®ä¸ã®æ ã«ã¯æåãå ¥åãããã¨ãã§ãã¾ãã</span><br />
<span style="color: #000000;">ããã赤ãæ ã§å²ã£ã¦ããæã®ä¸</span>ã«<br />
<strong><span style="color: #ff0000;">[<;43586]ggge&#8221;å¹´&#8221;m&#8221;æ&#8221;d&#8221;æ¥&#8221;</span></strong>;<strong><span style="color: #0000ff;">[<;43831]&#8221;æ°å å·1å¹´&#8221;m&#8221;æ&#8221;d&#8221;æ¥&#8221;</span></strong>;<strong><span style="color: #ff6600;">ggge&#8221;å¹´&#8221;m&#8221;æ&#8221;d&#8221;æ¥&#8221;</span></strong><br />
ãã³ãããã¦ãã ããã<br />
<img data-attachment-id="7817" data-permalink="https://www.eskyjapan.com/memo/excel_ge/attachment/20190501_6/" data-orig-file="https://i0.wp.com/www.eskyjapan.com/wp-content/uploads/2019/01/20190501_6.jpg?fit=570%2C540&;ssl=1" data-orig-size="570,540" data-comments-opened="0" data-image-meta="{";aperture";:";0";,";credit";:";";,";camera";:";";,";caption";:";";,";created_timestamp";:";0";,";copyright";:";";,";focal_length";:";0";,";iso";:";0";,";shutter_speed";:";0";,";title";:";";,";orientation";:";0";}" data-image-title="20190501_6" data-image-description="" data-image-caption="" data-medium-file="https://i0.wp.com/www.eskyjapan.com/wp-content/uploads/2019/01/20190501_6.jpg?fit=300%2C284&;ssl=1" data-large-file="https://i0.wp.com/www.eskyjapan.com/wp-content/uploads/2019/01/20190501_6.jpg?fit=449%2C425&;ssl=1" class="aligncenter size-full wp-image-7817" src="https://www.eskyjapan.com/wp-content/uploads/2019/01/20190501_6.jpg" alt="" width="570" height="540" /><br />
æå¾ã«ãOKãã§è¨å®ãå®äºãããã°ããã®ããã«è¡¨ç¤ºããã¦ããã¯ãã§ãã<br />
<img data-attachment-id="7818" data-permalink="https://www.eskyjapan.com/memo/excel_ge/attachment/20190501_7/" data-orig-file="https://i0.wp.com/www.eskyjapan.com/wp-content/uploads/2019/01/20190501_7.jpg?fit=450%2C130&;ssl=1" data-orig-size="450,130" data-comments-opened="0" data-image-meta="{";aperture";:";0";,";credit";:";";,";camera";:";";,";caption";:";";,";created_timestamp";:";0";,";copyright";:";";,";focal_length";:";0";,";iso";:";0";,";shutter_speed";:";0";,";title";:";";,";orientation";:";0";}" data-image-title="20190501_7" data-image-description="" data-image-caption="" data-medium-file="https://i0.wp.com/www.eskyjapan.com/wp-content/uploads/2019/01/20190501_7.jpg?fit=300%2C87&;ssl=1" data-large-file="https://i0.wp.com/www.eskyjapan.com/wp-content/uploads/2019/01/20190501_7.jpg?fit=450%2C130&;ssl=1" class="aligncenter size-full wp-image-7818" src="https://www.eskyjapan.com/wp-content/uploads/2019/01/20190501_7.jpg" alt="" width="450" height="130" /><br />
ãã®ã¾ã¾ã ã¨ã2020å¹´1æ1æ¥ã«ã¯ãã¾ãå¹³æã«æ»ã£ã¦ãã¾ããããå¹´æ«é ã«Excelãã¢ãããã¼ããã¦ããã¾ãããï¼<br />
ãã®é ã ã¨ãä¸å ·åã®ãªãExcelã®ã¢ãããã¼ããæå¾ ã§ãã¾ãã<br />
ã¡ãªã¿ã«ã”1å¹´”ã§ã¯ãªãã”å å¹´”ã¨è¡¨ç¤ºãããããªãããããã³ãããã¦ãã ããã<br />
<strong><span style="color: #ff0000;">[<;43586]ggge&#8221;å¹´&#8221;m&#8221;æ&#8221;d&#8221;æ¥&#8221;</span></strong>;<strong><span style="color: #0000ff;">[<;43831]&#8221;æ°å å·å å¹´&#8221;m&#8221;æ&#8221;d&#8221;æ¥&#8221;</span></strong>;<strong><span style="color: #ff6600;">ggge&#8221;å¹´&#8221;m&#8221;æ&#8221;d&#8221;æ¥&#8221;</span></strong></p>
<h4 class="style4a">ggge</h4>
<p>ãã®è¨å·ãæ°ã«ãªã£ã¦ãã人ããããããããªãã®ã§èª¬æãã¦ããã¾ãã<br />
åãã®ãgggãã§å å·è¡¨ç¤ºãä»ãªããå¹³æã<br />
ããããgãã ãï¼ã¤ã¾ããgeãï¼ã«ããã¨ãã¢ã«ãã¡ãããã®é æå表示ãä»ãªããHã<br />
æå¾ã®ãeãã¯å å·ã®æ°åãå ¥ãã¾ãã<br />
ã§ããããeãã ãã«ããã¨ãå å·ã®æ°åã ãã表示ããã¾ãã<br />
èªåã«åã£ã表示æ¹æ³ã§è¨å®ãã¦ãã ããã</p>
<h4 class="style4a">å å¹´</h4>
<p>ä»åã®æ¹æ³ã ã¨ãä»ã¾ã§æ°åã ã£ããï¼ãããå ãã«ãããã¨ãåºæ¥ã¾ãã<br />
ããã¦ãå ã»ã©èª¬æãããgggeããå¤æ´ãã¦ã¿ã¾ããã<br />
<span style="color: #000000;">[<;43586]<span style="font-size: 18pt;"><strong>ge</strong></span>&#8220;å¹´&#8221;m&#8221;æ&#8221;d&#8221;æ¥&#8221;;[<;43831]&#8221;æ°å å·<span style="font-size: 18pt;"><strong>å </strong></span>å¹´&#8221;m&#8221;æ&#8221;d&#8221;æ¥&#8221;;<span style="font-size: 18pt;"><strong>e</strong></span>&#8220;å¹´&#8221;m&#8221;æ&#8221;d&#8221;æ¥&#8221;</span><br />
ããããã¦ã¼ã¶ã¼å®ç¾©ãã«å ¥åãã¦è¨å®ããã¨ã次ã®Cåããã«è¡¨ç¤ºããã¾ãã<br />
<img data-attachment-id="7819" data-permalink="https://www.eskyjapan.com/memo/excel_ge/attachment/20190501_8/" data-orig-file="https://i0.wp.com/www.eskyjapan.com/wp-content/uploads/2019/01/20190501_8.jpg?fit=456%2C118&;ssl=1" data-orig-size="456,118" data-comments-opened="0" data-image-meta="{";aperture";:";0";,";credit";:";eiji";,";camera";:";";,";caption";:";";,";created_timestamp";:";1546902265";,";copyright";:";";,";focal_length";:";0";,";iso";:";0";,";shutter_speed";:";0";,";title";:";";,";orientation";:";0";}" data-image-title="20190501_8" data-image-description="" data-image-caption="" data-medium-file="https://i0.wp.com/www.eskyjapan.com/wp-content/uploads/2019/01/20190501_8.jpg?fit=300%2C78&;ssl=1" data-large-file="https://i0.wp.com/www.eskyjapan.com/wp-content/uploads/2019/01/20190501_8.jpg?fit=456%2C118&;ssl=1" class="aligncenter size-full wp-image-7819" src="https://www.eskyjapan.com/wp-content/uploads/2019/01/20190501_8.jpg" alt="" width="456" height="118" /></p>
<h3 class="style3b">ãããã«</h3>
<p>Excelãªã®ã§ãå¤ãã®äººãé¢æ°ã§ãã£ã¬ã³ã¸ãããã¨ãã¦ããã®ã§ãããé¢æ°ã使ãã¨ä½è¨ãªã»ã«ãåºæ¥ãããããããã¾ãæå¹ã¨ã¯æãã¾ããã®ã§ç§ã¯ã表示形å¼ãã使ã£ã¦ã¿ã¾ããã<br />
æééå®ã®æ¹æ³ãªã®ã§ãåºæ¥ãã ãå¤ãã®äººã«ã·ã£ã¢ãã¦ã»ããã¨æã£ã¦ãã¾ãã<br />
æå¾ã«èª¬æãã¦ãããå å¹´ãã®è¡¨ç¤ºã¯ããããããã¤ã¯ãã½ããã®ã¢ãããã¼ãã§ã対å¿ãããªãã¨æãã®ã§ãããã ãã§ã価å¤ã®ããè¨å®ã§ã¯ãªãã§ããããã<br />
åèè¨äºï¼<a href="https://www.eskyjapan.com/trend/era_name/">次ã®å å·ãäºæ¸¬</a><br />

<!-- WP QUADS Content Ad Plugin v. 2.0.99 -->
<div class="quads-location quads-ad3" id="quads-ad3" style="float:none;margin:0px;">

</div>
<br />

<!-- WP QUADS Content Ad Plugin v. 2.0.99 -->
<div class="quads-location quads-ad4" id="quads-ad4" style="float:none;margin:0px 0 0px 0;text-align:center;">

</div>
</p>


- 7年 ago
葉隠 瀧
Categories:
メモ
Excelで新元号に対応させる方法
Related Post
-
『お寺』と『神社』の違い
仏像があり、お坊さんが住むとこ…
-
0(ゼロ)は偶数か奇数か？
0を自然数と考えた場合、0は偶…
-
味の素を食べるとハゲる！
味の素が石油由来だった時代でも…