Extract report to excel 2002 format issue

[Cognos8]

while exporting report to excel 2002 format some of the records are not getting displayed in date format. instead of that it shows decimals format. there is no case calculation FM model. any one have faced this kind

[tupac_rd]

Is this the issue

http://www-01.ibm.com/support/docview.wss?rs=3442&context=SS9RTN&q1=%2bdate+%2bformat&uid=swg21338955&loc=en_US&cs=utf-8&cc=us&lang=all

[Cognos8]

Hi , your information is awesome... how you are finding the consolidate tech note... i would like to keep in touch with you

[tupac_rd]

http://www-01.ibm.com/support/search.wss?word=aw&wfield=date+format+in+Exce&nw=&apar=include&tc=SS9RTN&atrn=&atrv=&atrn1=&atrv1=&atrwcs=on&lang=all&dr=all&r=10&ibm-submit=Submit&cc=us&from=advs&loc=en_US&rs=3442&cs=utf-8

not sure if that is what you were looking for

[Cognos8]

thank you for your info. Back to my issue .. even  afterrr changing the settings i am getting 2 different format for date column. one is actual datttte another one is "39120.58819444", Cane u pls throw some light on this.