Format number with VBA Excel (+0.0%)

[blelli]

Dears,

How can I create a code to format the number like +0.0%.

I must have the operation's signal (+ or -)
I must have the percentage signal at end (%)

The user can type 1 and the system will show +1.0%
The user can type 1.0 and the system will show +1.0%
The user can type +1.0 and the system will show +1.0%
The user can type -1.0 and the system will show -1.0%

How can I do it?

Thanks

 

[Fluff]

How about +0.0%;-0.0%

 

[blelli]

How about +0.0%;-0.0%

Perfect!

Thank you

 

[Fluff]

You're welcome