Thanks for the feedback.
--
John C


"Hendrik.Kleine" wrote:

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