How to display the plus sign for positive numbers.

  • Thread starter Thread starter Tony Zannini
  • Start date Start date
T

Tony Zannini

Hi Helpers,
In some cells I want to display (and be able to print) the
plus sign in front of positive numbers just like I can
display the minus sign in front of negative numbers. Any
suggestions?
Thanks,
Tony
 
Just amend one of the existing formats, eg:-

Change the existing format of

#,##0;[Red]-#,##0

to

+#,##0;[Red]-#,##0

by simply adding a + to the positive side of the format
 
Mind you, I should have added that you need to put a 3rd argument in there for
what you want displayed if it is 0, else you will get +0 appear, eg:-

+#,##0;[Red]-#,##0;0

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



Ken Wright said:
Just amend one of the existing formats, eg:-

Change the existing format of

#,##0;[Red]-#,##0

to

+#,##0;[Red]-#,##0

by simply adding a + to the positive side of the format

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



Tony Zannini said:
Hi Helpers,
In some cells I want to display (and be able to print) the
plus sign in front of positive numbers just like I can
display the minus sign in front of negative numbers. Any
suggestions?
Thanks,
Tony
Click to expand...
Click to expand...
 
Back
Top