This format must help you to display + sign for positive numbers, - sign
for negative numbers and no sign for zero. If you want to display
decimals, add as many zeros after a decimal point. e.g,
+0.00;-0.00;0.00


--
raguraj
------------------------------------------------------------------------
raguraj's Profile: http://www.excelforum.com/member.php...o&userid=26186
View this thread: http://www.excelforum.com/showthread...hreadid=394921