<div>
Try using:<br />
<br />
=TEXT(Sheet11!BD401&amp;Sheet1<wbr />1!BE401, &quot;000&quot;)&amp;&quot; / &quot;&amp;TEXT(Sheet11!BF401&amp;&quot;C&quot;, &quot;00&quot;)
</div>


Try using:

=TEXT(Sheet11!BD401&Sheet11!BE401, "000")&" / "&TEXT(Sheet11!BF401&"C", "00")

<div>
Thanks NB, I didn't realize there were three calls.
</div>


Thanks NB, I didn't realize there were three calls.

<div>
<div class="content wysiwyg-content">
I have a formula in a cell =Sheet11!BD401&amp;Sheet11!BE4<wbr />01&amp;&quot; / &quot;&amp;Sheet11!BF401&amp;&quot;C&quot; &nbsp; How do I format the value of Sheet11!BD401 to 000, and Sheet11!BE401 formatted to 00
</div>
</div>


I have a formula in a cell =Sheet11!BD401&Sheet11!BE401&" / "&Sheet11!BF401&"C"   How do I format the value of Sheet11!BD401 to 000, and Sheet11!BE401 formatted to 00

Format data

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