I would like a cell to show a + or - sign before number.
+#,###;-#,###;
The last semi-colon eliminates the + sign from 0's
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"BVB1200" wrote in message
...
When showing numbers in a cell I would like positive numbers to be preceeded
with a + sign. I would like negative numbers to be preceeded by a - sign.
How
can I format to do this automatically?
|