Sammy -

+#,##0;-#,##0;#,##0

- Mike
www.mikemiddleton.com

"SammyJJones" wrote in message
...

Thank you SteveG,

1 problem however.... with this it shows "0" as "+0"..... any fix?


Thanks,
Sammy


SteveG Wrote:
Sammy,

Custom format your cells like this.


+#,##0;-#,##0

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=500596


--
SammyJJones