Thread: How do you make a plus sign appear in front of a number?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David McRitchie David McRitchie is offline
external usenet poster
  
Posts: 903
Default How do you make a plus sign appear in front of a number?
Format, cells, custom
+#,##0.00_);-#,##0.00;"";@

http://www.mvps.org/dmcritchie/excel...htm#cellformat
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"fairchildbrad" wrote in message
...
How do you make a "+" sign appear in front of positive numbers that you have
typed in?


Reply With QuoteReply With Quote