Data exported to excel 2007 changes cell number format to 'general' ?

[Former Member]

Hello,

After some transaction execution I get results, looks like table or grid. If I select standard Export->Spreadsheet when excel 2003 is installed, I get results as expected.

But if excel 2007 is installed, all number cells get number format 'general'. For example transaction result grid has date data '2009.06.03' (local date format). In excel 2003 this cell will get 'date' format (Fromat Cells...->Number) While in excell 2007 it will get 'general' format, and value will be 39967, if I change number format to 'date' manually it will have right value '2009.06.03'

So the data is preserver only format is lost.

How do I fix that ?

Our users feel uncomfortable because of that.

thanks

Vilius

[Former Member]

Anyone ?

[Former Member]

I have seen this type of problems with other application when we install new KBs. Did you check the fix on microsoft website for your kind of a problem?

[Former Member]

Hi,

I have office 2007 SP2 installed. If you have any references to MS article describing similar problems please point that.

thanks

Vilius