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
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
Hi , your information is awesome... how you are finding the consolidate tech note... i would like to keep in touch with you
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
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.