<div>
Since the data has a dash in it it is already a text string and thus you will be unable to use the numeric formatting options.<br />
<br />
Your only option is to use a formula.<br />
<br />
Kevin
</div>


Since the data has a dash in it it is already a text string and thus you will be unable to use the numeric formatting options.

Your only option is to use a formula.

Kevin

<div>
One formula is:<br />
<br />
=VALUE(LEFT(A1,FIND(&quot;-&quot;,A1<wbr />)-1))+VALU<wbr />E(MID(A1,F<wbr />IND(&quot;-&quot;,A1<wbr />)+1,9))/32<wbr /><br />
<br />
Kevin
</div>


One formula is:

=VALUE(LEFT(A1,FIND("-",A1)-1))+VALUE(MID(A1,FIND("-",A1)+1,9))/32

Kevin

<div>
Thanks Kevin for the quick response.<br />
<br />
I thought so but wanted to get it confirmed from a top expert :-)<br />
<br />
$wapnil
</div>


Thanks Kevin for the quick response.

I thought so but wanted to get it confirmed from a top expert :-)

$wapnil

<div>
<div class="content wysiwyg-content">
Hello experts,<br />
I am looking for a custom format in excel that will display the fixed income bond price, which can be 104-2 as 104.0625. Basically we have to divide the number after the - by 32 and add it to the number on the left hand side of the hypen.<br />
<br />
Can this be done? We do not want a UDF? We want something we can directly do in the excel sheet.<br />
<br />
Thanks for your time and support.<br />
<br />
$wapnil
</div>
</div>


Hello experts,
I am looking for a custom format in excel that will display the fixed income bond price, which can be 104-2 as 104.0625. Basically we have to divide the number after the - by 32 and add it to the number on the left hand side of the hypen.

Can this be done? We do not want a UDF? We want something we can directly do in the excel sheet.

Thanks for your time and support.

$wapnil

Custom Format Excel Cells for Bond Prices

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