<div>
0.0000%<br />
<br />
=&quot;&quot;&amp;BasicData!O14&amp;&quot;with a &quot;&amp;text(BasicData!O20,&quot;0.00<wbr />00%&quot;)&amp;&quot; Ownership Interest in &quot;&quot;The Company&quot;&quot; &quot;
</div>


0.0000%

=""&BasicData!O14&"with a "&text(BasicData!O20,"0.0000%")&" Ownership Interest in ""The Company"" "

<div>
That worked. &nbsp;Thanks. &nbsp;Bill
</div>


<div>
<div class="content wysiwyg-content">
I have the following formula...<br />
<br />
=&quot;&quot;&amp;BasicData!O14&amp;&quot;with a &quot;&amp;(BasicData!O20*100)&amp;&quot;% Ownership Interest in &quot;&quot;The Company&quot;&quot; &quot;<br />
<br />
The value of O20 is 0.51 and I need to show the value as 51.0000%, with 4 decimal places, regardless of whether they are zeroes or not.
</div>
</div>


I have the following formula...

=""&BasicData!O14&"with a "&(BasicData!O20*100)&"% Ownership Interest in ""The Company"" "

The value of O20 is 0.51 and I need to show the value as 51.0000%, with 4 decimal places, regardless of whether they are zeroes or not.

Showing a decimal as a 4-place percentage within an Excel cell

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