Please help me ?
sent from Visual Basic 6 show the wrong dates, examples of 12/10/2013 = calc '12/10/2013 not date format. not see the date format. How fix ?
Try to send in another format, such as 2013-12-10 (yyyy-mm-dd) or formatted date column in calc before sending.
You entered the date as text ("’" at the beginning and it is probably left-aligned). Edit the cell (F2) and delete the “’” at the beginning. Then right-click on the cell and select “Format Cell”, under “Number” you can select then the date format you want.
The date format shown in your example is the standart US format Month/Day/Year shown in formatting window as MM/DD/YYYY.