Add "+" plus symbol to positive percentage
Thank you very much both, worked like a charm :)
"John C" wrote:
Format|Cells|Custom
Custom number format:
+ #0.0# %;- #0.0# %
Hope this helps.
--
John C
"Hendrik.Kleine" wrote:
Hi, Im calculating a precentage of two figures:
A1= 100 A2=200
=(A1/A2)-1
This gives me a negative result "-50%"
When A1 is greater than A2, resulting in a positve result, I'd like it to
display "+50%". Right now the plus symbol is not included.
Tried to concatenate but can't figure it out.
Many thanks for all suggestions.
Hendrik
|