Excel question

[Dominion]

I have a sum in excel which outputs the difference of two numbers.

The output can either be negative or postive. Is there anyway to force excel to show a '+' for the positive numbers for presentation purposes.

I have a large amount of numbers and don't want to do it manually.

Thanks

[faulkner132]

=if(a1>0,concatenate("+",a1),a1)

[Dominion]

Thanks

I've done this and it works

=IF(C26-B26>0,CONCATENATE("+",(C26-B26)*1000),(C26-B26)*1000)

However when its a postive number it gives the answer as

+1.9999999999...

I think because concatenate is a text command excel does not round the number up?

********************EDIT*******************************

=IF(C27-B27>0,"+"&TEXT((C27-B27)*1000,"0"),(C27-B27)*1000)

got this to work