positive numbers with '+' sign

A

alekm

Hi,
is there any way I can present positive numbers together with '+' sign but not to
turn them into strings that start with '+', I need numbers to stay numbers.
Thanx

alekm
 
S

Sukhjeet

Hi Alekm
Format the cells containing these numbers in the following way:
Select the cells
Format->Cells
Select "Custom" in the category listbox
Type +0_);-0 in the Type text box
Press OK.
Now ur positive numbers will be shown beginning with a + and negatives with a -
Sukhjeet
 
Top