I have this fomula
="Amount due from related companies bear interest at "&Data!C22&" p.a("&Data!D21&": "&Data!C21&" p.a). They are unsecured and do not have any fixed terms of repayment."
The result is
Amount receivable from holding company bears an interest rate of 0.135 p.a.
How do I apply formatting so that I have it reading 13.5%
="Amount due from related companies bear interest at "&Data!C22&" p.a("&Data!D21&": "&Data!C21&" p.a). They are unsecured and do not have any fixed terms of repayment."
The result is
Amount receivable from holding company bears an interest rate of 0.135 p.a.
How do I apply formatting so that I have it reading 13.5%