positive numbers with '+' sign

[Guest]

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

 

[Andy B]

Hi

You could use a custom cell format like:
+0.00;-0.00;0.00

 

[Guest]

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