<div>
Format them as Accounting:<br />
<br />
<a href="http://office.microsoft.com/en-us/excel-help/display-numbers-as-currency-HP005241205.aspx" rel="ugc">http://office.microsoft.com/en-us/excel-help/display-numbers-as-currency-HP005241205.aspx</a>
</div>


Format them as Accounting:

http://office.microsoft.com/en-us/excel-help/display-numbers-as-currency-HP005241205.aspx [http://office.microsoft.com/en-us/excel-help/display-numbers-as-currency-HP005241205.aspx]

Screenshot-12-29-12-10-09-PM.png

<div>
Thanks for the clear code and example.
</div>


<div>
You're welcome and I'm glad I was able to help.<br />
<br />
Marty - MVP 2009 to 2012
</div>


You're welcome and I'm glad I was able to help.

Marty - MVP 2009 to 2012

<div>
<div class="content wysiwyg-content">
I have a message box that puts out 2 lines of currency values (along with text). &nbsp;<br />
<br />
Is there any way to format the currency so it aligns by decimal? (Accountant format)
</div>
</div>


I have a message box that puts out 2 lines of currency values (along with text).  

Is there any way to format the currency so it aligns by decimal? (Accountant format)

Accounting format

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