How to display the plus sign for positive numbers.

[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

 

[Ken Wright]

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

 

[Ken Wright]

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
----------------------------------------------------------------------------

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
----------------------------------------------------------------------------

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