can''t use decimals in formula.

[Galobart]

Hi,

I trying use this code:

hoja.Range["R" + numberFila].Formula = "=ROUND(P24*0.3%,2)";

But the result in excel is:

=ROUND(P24%*3,2) (without "0.")

Thanks for your help.

[Melba Winshia]

Hi Galobart,

I was not able to reproduce the problem. Here is the sample that I used for testing.

Formula.zip

Please take a look at the sample above and let me know if you have any other questions.

Regards,
Melba

[Administrator]

I have spanish version excel in my computer. I have severed problems with that. I solved it using "VALUE" in formula.

Thanks for answer.