Hi I am trying to create a statement in excel that will combine text and references to numbers, however the numbers need to be displayed as a %.
I am trying to use the Text function : TEXT(value, format_text) but instead of the options showing, I want to show it as % .... not possible?
My % is in cell D33 (and is a reference from somewhere else) and is formatted as %.
My text in cell A1 to show will look like this:
=IF(Language="ENG","ABC level is "&D33&" of annual premium","Provisionné ABC "&D33&" des primes annuelles")
However, the current result is :
ABC level is 0.1 of annual premium
I want it to look like this:
ABC level is 10% of annual premium
any tricks?
Bookmarks