write statement giving diffrent ouput when downloaded to spreadsheet

[Former Member]

Hi.

i am doing the same write statement for both the dates like march 3rd 09 and january 01 2008,but while downloading the file in spreasheet,the style is getting changed.i have tried using left-jiustified and condense keywords still the problem remains same.in the execution of report,both are coming in same style but here you can see that the sttyle is getting chnges.

please suggest what to do in such case.

thanks!

(All ship-tos)Report

3-Mar-09

06:28:42AM

January 01, 2008 to December 31, 2008

[former_member242255]

it may be some problem with the format of the cell at whcih it is getting filled..

please check the properties of the cell..

[Former Member]

Hi, Format the cells in Excel sheet.

The problem may not be in WRITE Statement

[Former Member]

thanks.

my problem got solved as there was nothing in the write statement.

the format of date was getting changed because in excel,it was purely a date so i made the dot concatenated with it to make it as string.

thnaks!