Date in Excel

I am pretty sure that is because of your regional settings, go to Windows control panel, 'clock, language and region' (in Win 7, may be different in other versions) then set you default date format. It works for me :)

I am pretty sure that is because of your regional settings, go to Windows control panel, 'clock, language and region' (in Win 7, may be different in other versions) then set you default date format. It works for me :)

no that is not working. the first half of the excel i create has the wrong date (mm/dd/yyyy) and the second half the correct (dd/mm/yyyy)

what happens when you format the line/row with the correct style before you fill the value?

ok how can i format it? what i have to do can you explain step by step the commands?

thas my code

          MOVE  ET-HMERA            TO W-BX-EXCEL-HMERA        

          MOVE  ET-MHNAS            TO W-BX-EXCEL-MHNAS        

          MOVE  ET-ETOS             TO W-BX-EXCEL-ETOS

          MOVE W-BX-EXCEL-DATE TO W-BX-EXCEL-TEMP

          MODIFY olWrkSh Range(TARGET)::Value = W-BX-EXCEL-TEMP          

     *     MODIFY olWrkSh Range(TARGET)::NumberFormat = "dd/mm/yyyy"

          PERFORM INCREASE-COLUMN-COUNTERS

OK i found that if i do that command the date remains i want.

MODIFY olWrkSh Range(TARGET)::NumberFormat = "@".

Thanks a lot!!!