Hi,

I've got two formatting problems when I export a report into excel:

1) If I have percentage values > than 100, e.g. 103,94 %, then Excel displays "######" in the exported file.
But if I have values < than 100, e.g 27,34 %, then Excel displays 27,34 %
I tested lots of formatting types in style->exel->Formatting-override, but I didn't get the right formating type

2) If i have date fields I use following formatting: "dd.mm.yy" but actually I want to see the dates like this: "dd.mm.yyyy".
But if I use that formatting type I just got "######" in excel

Does anybody know what the right formatting is?