I am facing funny problem.
I have a varialble, please see below
I_LGTYP TYPE CHAR10
I_LGTYP = '01-01-01'.
when i write this value into XLS file using GUI_DOWNLOAD FM, It is converting as Date and writing in Excel as 1/1/2001
i tried different options by declaring I_LGTYP as NUM10 and then it is writing as 10101
String same as CHAR.
please tell me how can i reslove this problem as i would like to see in Excel as 01-01-01.
I tried typing 01-01-01 in excel it immediatley changed to date format 1/1/2001, then i tried '01-01-01 and this time it works.
Vishnu, thanks for reply
how can i send variable insted of value?
for example if i send like below
WA_RECORD-STO_BIN = '''WA_LQUA-LGPLA'.
Note : WA_LQUA-LGPLA variable has value 01-01-01
If i write above statement in program the output I am getting in excel as WA_LQUA-LG (since the variable is 10 long)
so, put your leading single quote on the value and "fool" Excel. This is an Excel "feature" that we've all had to deal with....there are other fixes, I'm sure.
And, seriously, Microsoft products cause such severe problems....so, search the forums for these basic problems....it's been asked a few hundred times before....
Edited by: BreakPoint on Nov 10, 2011 5:36 PM