Positive sign

[richard.woollacott]

Can anyone help please?
In a group of cells containing calculated figures, I would like positive
numbers to be preceded with the + sign. Can anyone tell me how to do it. I
suspect that the text command is what I want, but I cannot find a way of
adding it to the section after the ,

The formula I am using is :
=IF(C15=B15,"On Budget",(C15-B15)/B15*100)

 

[Frank Kabel]

Hi Richard
one way: Apply the following custom format to this cell (goto 'Format -
Cells'):
+#,##0.00;-#,##0.00 ;0.00

 

[richard.woollacott]

Many thanks - works a treat!