Cool,

Thanks heaps everyone, great help.

Cheers,

Aaron.


Desert Piranha wrote:

Slashman Wrote:
Hi,

I know excel displays negative numbers prefixed with a - sign, is it
possible to easily have excel put a + sign before positive numbers
automatically?

Any help greatly appreciated,

Cheers,

Aaron.Hi Slashman,

To add to the other great responces.
Puts a plus sign in front of positive amounts, a minus before
negatives, and nothing in front of zeroes.

something like:
+#,##0.0;"-"#,##0.0;#,##0.0

+#,##0.00;"-"#,##0.00;#,##0.00

0.3 becomes +0.3 or as in the second line +0.30


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=572870