<div>
<div class="content wysiwyg-content">
Hi, I have some formula <br />
<br />
=&quot;YTD &quot;&amp;J12<br />
<br />
J12 needs the custom formatting &nbsp;$#,,&quot; M&quot;; <br />
<br />
So I've tried the formula<br />
<br />
=&quot;YTD &quot;&amp;text(J12, $#,,&quot; M&quot;; )<br />
<br />
Its getting a syntax error, can anyone amend?<br />
<br />
Thanks
</div>
</div>


Hi, I have some formula 

="YTD "&J12

J12 needs the custom formatting  $#,," M"; 

So I've tried the formula

="YTD "&text(J12, $#,," M"; )

Its getting a syntax error, can anyone amend?

Thanks

CONCATENATE NUMBER AND TEXT FORMATTING

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