Excel automation

giulio.cipo

Hi,

i'm working with excel automation and i should format a cell.
i have already done this without problem but now i shoul change color of cell depends of sign.

I used this code but in run time the sistem retun me an error :

Sheet.range(....).numberformat := '###0,00;[Red]###0,00';

the error is : impossible define the numbert format property for Class range.

I'm working with italian version and i'm coping code from excel macro but it doesn't work.

some have already solved this problem?
thanks

Christian_Buehl

swap dot and comma

....numberformat('###0.00;[Red]###0.00')
and it should work.
The Interface is using the US-English style for Number fomatting. They use dots instead of comma and vice versa.