<div>
Excellent thanks for the feedback..
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts using excel 2010<br />
<br />
Using the following formula <br />
B6 =K6&amp;&quot;--&quot;&amp;TEXT($B$1,&quot;00000&quot;<wbr />)<br />
B7 =K6&amp;&quot;--&quot;&amp;TEXT(RIGHT($B6,5)<wbr />+$B$1),&quot;00<wbr />000&quot;)<br />
<br />
Cannot get the B7 one to work....
</div>
</div>


Hi Experts using excel 2010

Using the following formula 
B6 =K6&"--"&TEXT($B$1,"00000")
B7 =K6&"--"&TEXT(RIGHT($B6,5)+$B$1),"00000")

Cannot get the B7 one to work....

Error in formula not increasing value

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