{"id":162,"date":"2014-06-11T12:01:16","date_gmt":"2014-06-11T03:01:16","guid":{"rendered":"http:\/\/akal.co.kr\/?p=162"},"modified":"2014-06-11T12:03:05","modified_gmt":"2014-06-11T03:03:05","slug":"%eb%a6%ac%eb%b8%8c%eb%a0%88%ec%98%a4%ed%94%bc%ec%8a%a4-tip-excel%ec%97%91%ec%85%80%ec%9d%98-numberstring-%ed%95%a8%ec%88%98%eb%a5%bc-%eb%8c%80%ec%b2%b4%ed%95%98%eb%8a%94-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"https:\/\/akal.co.kr\/?p=162","title":{"rendered":"[\ub9ac\ube0c\ub808\uc624\ud53c\uc2a4 TIP] Excel(\uc5d1\uc140)\uc758 NUMBERSTRING \ud568\uc218\ub97c \ub300\uccb4\ud558\ub294 \ubc29\ubc95"},"content":{"rendered":"<p><span class=\"dropcap\">\ub9ac<\/span>\ube0c\ub808\uc624\ud53c\uc2a4\ub098 \uc624\ud508\uc624\ud53c\uc2a4\uc5d0\uc11c\ub294 MS Excel\uc5d0\uc11c \uc9c0\uc6d0\ud558\ub294 numberstring \ud568\uc218\ub97c \uc9c0\uc6d0\ud558\uc9c0 \uc54a\ub294\ub2e4. \uacac\uc801\uc11c \ub4f1\uc5d0\uc11c \ud55c\uae00 \uc11c\uc218\ub85c \uc22b\uc790\ub97c \ud45c\ud604\ud560\ub54c \uaf2d \ud544\uc694\ud55c \ud568\uc218\uc778\ub370 \uc0dd\uac01\uc678\ub85c \uaf2d \ud544\uc694\ud560 \ub54c\uac00 \uc885\uc885 \uc788\uc5b4\uc11c \ub9ac\ube0c\ub808\uc624\ud53c\uc2a4\uc5d0\uc11c\ub3c4 \uc9c0\uc6d0\ud558\ub294 \ubc29\ubc95\uc744 \ucc3e\uc544\ubd24\ub2e4. \ub9ac\ube0c\ub808\uc624\ud53c\uc2a4\uc5d0\uc11c\ub294 TEXT\ud568\uc218\ub97c \uc774\uc6a9\ud574\uc11c \uc11c\uc2dd\uc744 \uc7a1\uac70\ub098 \uc22b\uc790 \ud3ec\ub9f7\uc744 \uc7a1\uc544\uc8fc\ub294 \uc11c\uc2dd\uc744 \uc774\uc6a9\ud574\uc11c \ubbf8\ub9ac \uc124\uc815\ud574\uc11c \uc0ac\uc6a9\ud558\uba74 \ub41c\ub2e4. \uc790\uc8fc \uc0ac\uc6a9\ud558\ub294 \ud615\ud0dc\ub97c \uc11c\uc2dd\uc73c\ub85c \ub4f1\ub85d\ud574\ub193\uace0 \uc0ac\uc6a9\ud568\uc73c\ub85c\uc368 \uc5b4\ub5a4\uba74\uc5d0\uc11c\ub294 \ud568\uc218\ub97c \uc774\uc6a9\ud558\ub294 \uac83\ubcf4\ub2e4 \ud6e8\uc52c \ud3b8\ud558\uac8c \uc0ac\uc6a9\ud560\uc218\ub3c4 \uc788\ub2e4.<\/p>\n<p style=\"color: #ff0000; text-align: center;\">\ucd94\ucc9c \uafb9~~!! \ubd80\ud0c1\ub4dc\ub9bd\ub2c8\ub2e4.<br \/>\n[daumview type=&#8221;button&#8221;][\/daumview]<\/p>\n<p>\uc11c\uc2dd\uc740 [NatNum1] ~ [NatNum11] \uc911 \ud558\ub098\ub97c \uc120\ud0dd\ud574\uc11c \uc0ac\uc6a9\ud558\uba70, \ud574\ub2f9 \ubaa9\ub85d\uc740 \uc544\ub798 \uc2a4\ud06c\ub9b0\uc0f7\uacfc \uac19\ub2e4. 12\ubc88\uc9f8\ub294 \uc751\uc6a9\ud574\uc11c \uc791\uc5c5\ud558\ub294 \ubc29\ubc95\uc744 \uc608\ub85c \ub4e4\uc5c8\ub2e4.<br \/>\n<a href=\"http:\/\/akal.co.kr\/wordpress\/wp-content\/uploads\/2014\/06\/003-01.png\" data-rel=\"lightbox-image-0\" data-rl_title=\"003-01\" data-rl_caption=\"\" title=\"003-01\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-163 aligncenter\" src=\"http:\/\/akal.co.kr\/wordpress\/wp-content\/uploads\/2014\/06\/003-01.png\" alt=\"003-01\" width=\"437\" height=\"347\" srcset=\"https:\/\/akal.co.kr\/wordpress\/wp-content\/uploads\/2014\/06\/003-01.png 437w, https:\/\/akal.co.kr\/wordpress\/wp-content\/uploads\/2014\/06\/003-01-300x238.png 300w\" sizes=\"(max-width: 437px) 100vw, 437px\" \/><\/a><\/p>\n<h4>1. \uc140\uc5d0\uc11c \uc9c1\uc811 TEXT\ud568\uc218\ub97c \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95<\/h4>\n<p>=TEXT(\uc22b\uc790,\uc11c\uc2dd) \ud639\uc740 =TEXT(\uc140\ubc88\ud638, \uc11c\uc2dd)\uc744 \uc774\uc6a9\ud55c\ub2e4.<\/p>\n<p>\uc0ac\uc6a9\uc608]<br \/>\n=TEXT(12345, &#8220;[NatNum10]#&#8221;)<br \/>\n=TEXT(B12, &#8220;[NatNum10]#&#8221;)<\/p>\n<p>\uc704\uc640 \uac19\uc740 \ubc29\ubc95\uc73c\ub85c \uc140\uc5d0 \uc9c1\uc811 \ud568\uc218\ub97c \uc368\ub123\uc73c\uba74 \uc5d1\uc140\uc5d0\uc11c \uc0ac\uc6a9\ud55c numberstring \ud568\uc218\uc640 \ub611\uac19\uc740 \ud6a8\uacfc\ub97c \ubcfc \uc218 \uc788\ub2e4.<\/p>\n<h4>2. \uc140 \uc11c\uc2dd\uc9c0\uc815\uc5d0 \ub4f1\ub85d \ud574\ub193\uace0 \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95<\/h4>\n<p><a href=\"http:\/\/akal.co.kr\/wordpress\/wp-content\/uploads\/2014\/06\/003-02.png\" data-rel=\"lightbox-image-1\" data-rl_title=\"003-02\" data-rl_caption=\"\" title=\"003-02\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-164 aligncenter\" src=\"http:\/\/akal.co.kr\/wordpress\/wp-content\/uploads\/2014\/06\/003-02.png\" alt=\"003-02\" width=\"293\" height=\"308\" srcset=\"https:\/\/akal.co.kr\/wordpress\/wp-content\/uploads\/2014\/06\/003-02.png 293w, https:\/\/akal.co.kr\/wordpress\/wp-content\/uploads\/2014\/06\/003-02-285x300.png 285w\" sizes=\"(max-width: 293px) 100vw, 293px\" \/><\/a><\/p>\n<p>\uc544\ubb34 \uc140\uc774\ub098 \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd \ubc84\ud2bc\uc744 \ub204\ub974\uba74 \uc140 \uc11c\uc2dd \uc9c0\uc815\uc774 \uac00\ub2a5\ud55c \ud31d\uc5c5 \uba54\ub274\uac00 \ub098\uc624\ub294\ub370 \uc774 \uba54\ub274\ub97c \uc120\ud0dd\ud574\uc11c \uc544\ub798 \uadf8\ub9bc\uacfc \uac19\uc774 \uc9c0\uc815\ud55c\ub2e4.<\/p>\n<p><a href=\"http:\/\/akal.co.kr\/wordpress\/wp-content\/uploads\/2014\/06\/003-03.png\" data-rel=\"lightbox-image-2\" data-rl_title=\"003-03\" data-rl_caption=\"\" title=\"003-03\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-165 aligncenter\" src=\"http:\/\/akal.co.kr\/wordpress\/wp-content\/uploads\/2014\/06\/003-03.png\" alt=\"003-03\" width=\"676\" height=\"418\" srcset=\"https:\/\/akal.co.kr\/wordpress\/wp-content\/uploads\/2014\/06\/003-03.png 676w, https:\/\/akal.co.kr\/wordpress\/wp-content\/uploads\/2014\/06\/003-03-300x185.png 300w\" sizes=\"(max-width: 676px) 100vw, 676px\" \/><\/a><\/p>\n<p>\u2460\ubc88 \uc11c\uc2dd\ucf54\ub4dc \ucc3d\uc5d0 \uc55e\uc5d0\uc11c \ub098\uc628 \uc11c\uc2dd \ubaa9\ub85d \uc911 \uc0ac\uc6a9\ud558\uace0 \uc2f6\uc740 \uc11c\uc2dd\uc744 \ud558\ub098 \uc785\ub825\ud55c\ub2e4.<br \/>\n\u2461 \uc11c\uc2dd\uc744 \uc791\uc131\ud55c\ud6c4 \ucd94\uac00 \ubc84\ud2bc\uc744 \ub204\ub974\uba74 \u2462\ubc88 \ubbf8\ub9ac\ubcf4\uae30 \ucc3d\uc5d0 \uc788\ub294 \uac83\uacfc \ub611\uac19\uc740 \uc11c\uc2dd\uc774 \ubc94\uc8fc \uc624\ub978\ucabd \uc11c\uc2dd\ucc3d\uc5d0 \uc0dd\uc131\ub41c\ub2e4. \ud574\ub2f9\uc11c\uc2dd\uc744 \uc120\ud0dd\ud558\uace0 \ud655\uc778\uc744 \ub20c\ub7ec\uc11c \uc11c\uc2dd\uc744 \uc9c0\uc815\ud574\uc8fc\uae30\ub9cc \ud558\uba74 \ub41c\ub2e4.<\/p>\n<p>\uc774 \ubc29\ubc95\uc73c\ub85c \uc11c\uc2dd\uc744 \uc9c0\uc815\ud574\ub450\uba74 \uacc4\uc18d\ud574\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\uae30 \ub54c\ubb38\uc5d0 \ud568\uc218\uc5d0 \uc57d\ud55c \uc0ac\uc6a9\uc790\ub4e4\ub3c4 \uc27d\uac8c \uc0ac\uc6a9\ud560 \uc218 \uc788\uac8c \ub41c\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ub9ac\ube0c\ub808\uc624\ud53c\uc2a4\ub098 \uc624\ud508\uc624\ud53c\uc2a4\uc5d0\uc11c\ub294 MS Excel\uc5d0\uc11c \uc9c0\uc6d0\ud558\ub294 numberstring \ud568\uc218\ub97c \uc9c0\uc6d0\ud558\uc9c0 \uc54a\ub294\ub2e4. \uacac\uc801\uc11c \ub4f1\uc5d0\uc11c \ud55c\uae00 \uc11c\uc218\ub85c \uc22b\uc790\ub97c \ud45c\ud604\ud560\ub54c \uaf2d \ud544\uc694\ud55c \ud568\uc218\uc778\ub370 \uc0dd\uac01\uc678\ub85c \uaf2d \ud544\uc694\ud560 \ub54c\uac00 \uc885\uc885 \uc788\uc5b4\uc11c \ub9ac\ube0c\ub808\uc624\ud53c\uc2a4\uc5d0\uc11c\ub3c4 \uc9c0\uc6d0\ud558\ub294 \ubc29\ubc95\uc744 \ucc3e\uc544\ubd24\ub2e4. \ub9ac\ube0c\ub808\uc624\ud53c\uc2a4\uc5d0\uc11c\ub294 TEXT\ud568\uc218\ub97c \uc774\uc6a9\ud574\uc11c \uc11c\uc2dd\uc744 \uc7a1\uac70\ub098 \uc22b\uc790&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":165,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[62],"tags":[69,68,79,67,78],"_links":{"self":[{"href":"https:\/\/akal.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/162"}],"collection":[{"href":"https:\/\/akal.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/akal.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/akal.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/akal.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=162"}],"version-history":[{"count":0,"href":"https:\/\/akal.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/162\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/akal.co.kr\/index.php?rest_route=\/wp\/v2\/media\/165"}],"wp:attachment":[{"href":"https:\/\/akal.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=162"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/akal.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=162"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/akal.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=162"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}