Thread: I would like a cell to show a + or - sign before number.
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default I would like a cell to show a + or - sign before number.
Format cells as:

custom==+#,##0;-#,##0

HTH

"BVB1200" wrote:

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?
Reply With QuoteReply With Quote