<div>
Once again, perfect!<br />
<br />
One more to go....
</div>


<div>
<div class="content wysiwyg-content">
I now have a cell which looks like this...<br />
<br />
=IF(B43&lt;&gt;&quot;&quot;,&quot;Value of &quot;&amp;B43&amp; &quot;'s &quot;&nbsp;&amp;B44&amp; &quot;% Ownership Interest&quot;,&quot;You must enter a name in B43&quot;)<br />
<br />
I need the value of B44 to always display with two decimals, even when the value of B44 is xx.00
</div>
</div>


I now have a cell which looks like this...

=IF(B43<>"","Value of "&B43& "'s " &B44& "% Ownership Interest","You must enter a name in B43")

I need the value of B44 to always display with two decimals, even when the value of B44 is xx.00

Manipulating the display/format of a numeric value inserted into a text cell in Excel

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

Microsoft Excel

An office suite is a collection of bundled productivity software (a software suite) intended to be used by knowledge workers. The components are generally distributed together, have a consistent user interface and usually can interact with each other, sometimes in ways that the operating system would not normally allow. Most contain a word processor, a spreadsheet, an email client and presentation software; some might contain a database program. Several office suites have their own topics: Microsoft Office, Office 365, LibreOffice (also known as OpenOffice), Lotus IBM and Google Apps.

Office Suites-Other

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.