• Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Excel format query

gadgetman

Fingers like lightning
Joined
Nov 10, 2006
Messages
662
Likes received
0
Thanks received
0
Location
The land down under
I need to format a cell as follows:

For positive numbers: with a '+' sign and two decimal places
For negative numbers: with a '-' sign and two decimal places
Zero: no sign and no DP i.e. '0'

I've tried cobbling it together but I keep getting things like '+0.'. Any ideas what the custom format should be?
 

Advertisers

Back
Top