Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you make a plus sign appear in front of a number?
How do you make a "+" sign appear in front of positive numbers that you have
typed in? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you make a plus sign appear in front of a number?
Select yoiur range, click on Format Cells. Select Custom, and type the
following: +#,##0;-#,##0 -- Hth Kassie Kasselman "fairchildbrad" wrote: How do you make a "+" sign appear in front of positive numbers that you have typed in? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you make a plus sign appear in front of a number?
Thanks guys. That helped solve my problem.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
equal sign in front of date in formual bar | Excel Worksheet Functions | |||
Creating zero's in front of number and after number | Excel Discussion (Misc queries) | |||
How do I find and replace a number with a minus sign in front? | Excel Discussion (Misc queries) | |||
Plus sign in front of a formula | Excel Discussion (Misc queries) | |||
How do I show a multiplication sign in front of a number | Excel Discussion (Misc queries) |