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.