<![CDATA[
<div><p>========================================================================================</p>
<p>현재 사용하는 엑셀 버젼을 기재하시면 좀더 <span style="FONT-SIZE: 11pt"><strong><font color="#112a75">정확하고 신속한 답변</font></strong></span>을 얻으실 수 있습니다. </p>
<p> </p>
<p><strong><span style="FONT-SIZE: 11pt">엑셀 버젼(<font color="#e31600">예: 2007</font>) :2010</span></strong></p>
<p><strong><span style="FONT-SIZE: 11pt"></span></strong>========================================================================================</p>
<p> </p></div><p>문제 숫자앞에 "0"을 집어넣어 4자리로 통일하는 법</p><table border="0" cellpadding="0" cellspacing="0" width="100" style="border-collapse: collapse;width:75pt">
<colgroup><col width="55" style="mso-width-source:userset;mso-width-alt:1760;width:41pt">
<col width="45" style="mso-width-source:userset;mso-width-alt:1440;width:34pt">
</colgroup><tbody><tr height="18" style="height:13.5pt">
<td height="18" class="xl76" width="55" style="height:13.5pt;width:41pt">지번</td>
<td class="xl76" width="45" style="border-left:none;width:34pt">부번1</td>
</tr>
<tr height="22" style="height:16.5pt">
<td height="22" class="xl75" width="55" style="height:16.5pt;border-top:none; width:41pt">447</td>
<td class="xl75" width="45" style="border-top:none;border-left:none;width:34pt">10</td>
</tr>
<tr height="22" style="height:16.5pt">
<td height="22" class="xl75" width="55" style="height:16.5pt;border-top:none; width:41pt">447</td>
<td class="xl75" width="45" style="border-top:none;border-left:none;width:34pt">2</td>
</tr>
<tr height="22" style="height:16.5pt">
<td height="22" class="xl75" width="55" style="height:16.5pt;border-top:none; width:41pt">3</td>
<td class="xl75" width="45" style="border-top:none;border-left:none;width:34pt">7</td>
</tr>
<tr height="22" style="height:16.5pt">
<td height="22" class="xl75" width="55" style="height:16.5pt;border-top:none; width:41pt">12</td>
<td class="xl75" width="45" style="border-top:none;border-left:none;width:34pt">7</td>
</tr>
<tr height="22" style="height:16.5pt">
<td height="22" class="xl75" width="55" style="height:16.5pt;border-top:none; width:41pt">583</td>
<td class="xl75" width="45" style="border-top:none;border-left:none;width:34pt">189</td>
</tr></tbody></table>해답<div><table border="0" cellpadding="0" cellspacing="0" width="144" style="border-collapse: collapse;width:108pt">
<colgroup><col width="72" span="2" style="width:54pt">
</colgroup><tbody><tr height="18" style="height:13.5pt">
<td height="18" class="xl75" width="72" style="height:13.5pt;width:54pt">지번</td>
<td class="xl75" width="72" style="border-left:none;width:54pt">부번1</td>
</tr>
<tr height="22" style="height:16.5pt">
<td height="22" style="height:16.5pt">0447</td>
<td>0010</td>
</tr>
<tr height="22" style="height:16.5pt">
<td height="22" style="height:16.5pt">0447</td>
<td>0002</td>
</tr>
<tr height="22" style="height:16.5pt">
<td height="22" style="height:16.5pt">0003</td>
<td>0007</td>
</tr>
<tr height="22" style="height:16.5pt">
<td height="22" style="height:16.5pt">0012</td>
<td>0007</td>
</tr>
<tr height="22" style="height:16.5pt">
<td height="22" style="height:16.5pt">0583</td>
<td>0189</td>
</tr></tbody></table><p><a href='javascript:fileFilterViewer("http://cfile273.uf.daum.net/attach/2574C5505708EA5D279178", "/cfile273/25/74C5505708EA5D279178", "문제.xlsx", "grpid%3D1GIVp%26fldid%3DK4Nh%26dataid%3D2722%26fileid%3D1%26regdt%3D20160409204125&url=http%3A%2F%2Fcfile273.uf.daum.net%2Fattach%2F2574C5505708EA5D279178")'><img src="https://t1.daumcdn.net/daumtop_deco/icon/icon.hanmail.net/editor/p_etc_s.gif" border="0" alt="첨부파일" class="vam"/> 문제.xlsx</a></p><p><br></p><p><br></p></div><p><br></p>
<!-- -->
]]>
카페 게시글
묻고 답하기(파일 첨부)
고수님들의 조언 긴급히 부탁드립니다._숫자앞에 "0"을 집어넣어 4자리로 통일하는 법
스페이스초이
추천 1
조회 215
16.04.09 20:41
댓글 4
다음검색
첫댓글 =REPT("0",4-LEN(A3))&A3
이케요?
정말 간단한 설명에 감탄을 드리며 고수님들의 친절한 조언에 힘입어 열심히 배우겠습니다.
삭제된 댓글 입니다.
감사합니다