<div>
Thanks for the quick response! I have a question on how to handle if it's not in A1. <br />
<br />
If it's not in A1, do I simply change all A1 to be the cell it's in? Does this include $A$1 or no?<br />
<br />

</div>


Thanks for the quick response! I have a question on how to handle if it's not in A1.

If it's not in A1, do I simply change all A1 to be the cell it's in? Does this include $A$1 or no?



<div>
No. Do not change the $A$1 references. That is used as a trick to make the SUMPRODUCT function work. The same formula assuming the value is in A2:<br />
<br />
&nbsp; &nbsp;=9-MOD(SUMPRODUCT(VALUE(MI<wbr />D(A2,ROW(O<wbr />FFSET($A$1<wbr />,0,0,LEN(A<wbr />2))),1))*(<wbr />MOD(ROW(OF<wbr />FSET($A$1,<wbr />17-LEN(A2)<wbr />,0,LEN(A2)<wbr />)),2)*2+1)<wbr />)-1,10)<br />
<br />
Kevin
</div>


No. Do not change the $A$1 references. That is used as a trick to make the SUMPRODUCT function work. The same formula assuming the value is in A2:

   =9-MOD(SUMPRODUCT(VALUE(MID(A2,ROW(OFFSET($A$1,0,0,LEN(A2))),1))*(MOD(ROW(OFFSET($A$1,17-LEN(A2),0,LEN(A2))),2)*2+1))-1,10)

Kevin

<div>
<div class="content wysiwyg-content">
I have a listing of 11-digit codes that I need to create into UPC-A codes to store in Excel, the barcode is not required. Can someone create a macro with install directions?<br />
<br />
I have the UPC Code in one column and want to get the UPC-A (with check digit code) in the column next to it<br />

<pre><code id="code-324845">UPC CODE	UPC-A Code
69681200001	
69681200002	
69681200003	
69681200004	
69681200005	
69681200006	
69681200007	
69681200008	
69681200009	
69681200010	
69681200011	
69681200012	
69681200013	
69681200014	
69681200015	
69681200016
69681200017
</code></pre>
</div>
</div>


I have a listing of 11-digit codes that I need to create into UPC-A codes to store in Excel, the barcode is not required. Can someone create a macro with install directions?

I have the UPC Code in one column and want to get the UPC-A (with check digit code) in the column next to it

UPC-A codes check digit macro request

Office Productivity refers both to the act of being productive and efficient in an office or professional environment, as well as the software applications used to "produce" information. This includes the development of professional skills, creating work processes, and almost any program used to create or modify a document, image, audio or video clip. However, business application suites such as Microsoft Office, which include word processing, spreadsheet and presentation programs, are typically called productivity software, as contrasted with a "utility program," such as a file manager, which is used to organize files and folders on the computer. Many office- and business-oriented groups of programs are organized into suites.

Office Productivity

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.