Excelã®è‡ªå‹•è¨ˆç®—ã§ç·¯åº¦ãƒ»çµŒåº¦ã‚’60進法⇔10進法ã§ç›¸äº’変æ›ã—ãŸã„ - OKWAVE＞経度139453.5　⇔　経度139.759774 ã¾ãšã“ã‚Œã¯å¤‰ã§ã™ã。経度139.759774ãªã‚‰1394535.19ã«ãªã‚‹ã¯ãšã§ã™ã€‚ ã¨ã‚‚ã‚れ計算å¼ã¯ã€A1ã«1394535.19ãŒã‚ã‚‹ã¨ã =INT(A1/10^4)+INT(MOD(A1,10^4)/100)/60+MOD(A1,100)/60^2 ã§139.759774ãŒæ±‚ã‚られã¾ã™ã€‚ ã¾ãŸA2ã«139.759774ãŒã‚ã‚‹ã¨ã =VALUE(INT(A2)&TEXT(INT(MOD(A2,1)*60),"00")&TEXT(MOD(MOD(A2,1)*60,1)*60,"00.00")) ã§1394535.19ãŒæ±‚ã¾ã‚Šã¾ã™ã€‚ æ„味ã¯è€ƒãˆã¦ã¿ã¦ãã ã•ã„。上ã®å¼ã®æ–¹ãŒè€ƒãˆã‚„ã™ã„ã¨æ€ã„ã¾ã™ã€‚下ã®å¼ã¯ãã®å対を行ã£ã¦ã„ã‚‹ã ã‘ã§ã™ï¼ˆãŸã ã—æ¡æ•°ã‚’åˆã‚ã›ã‚‹ãŸã‚ã€ä¸€æ—¦æ–‡å—列ã«ã—ã¦ã„ã¾ã™ãŒï¼‰
{{#tags}}- {{label}}
{{/tags}}