Try:-
"+"#,##0 ;[Red]"-"#,##0

Mike


"Michel Khennafi" wrote:

Good morning

I have 2 cells I need to compa
- one cell is the baseline (assume $100)
- the other cell is the real cost obtained after a calculation from other
cells (assume the resulkt of the calculation is $106)
- I would like to calculate the difference between cell 1 and cell 2 and
present it with a + or - sign, in my situation cell 2 is equal to +6

Any idea as to how I would need to format the cell? creation of a custom
format?

Thanks for your help

Regards,

Michel