Re : Re: transfer data into excel????

[snta1806]

i want transfer data (in format date) from multicolumn listbox into microsoft excel..the data can transfer,but date format had changed..

for example:-

in multicolumn listbox,the date in format dd/mm/yyyy. after transfer to microsoft excel,the date format had changed into mm/dd/yyyy...

why this happened???

any solution???/

[Semper_discens]

I believe that Excel default date formats are taken from Windows general settings.

Go to Control Panel > Regional and Language Options and change the "Short Date" format.

[smercurio_fc]

Or, instead of changing the format for the entire operating system, simply change the format for that column in the Excel sheet.

[chilly_charly]

There is another thread dealing with exactly the same problem ! There are several issues with the date format in Excel, related to the default settins and language used. Format the destination cells as string (fortunately the code format - @ - seems to be universal) and you will avoid a lot of problems.

[smercurio_fc]

CC, I think you meant this thread.

[chilly_charly]

---

smercurio_fc a écrit:
CC, I think you meant this thread.

---

Yes of course. Sorry for the recursivity ! Anyway that gave a good idea of the closeness of the two threads ! :D:D

[snta1806]

if my date; 01/12/2008 (dd/mm/yyyy) the problem will be coming...

it's will transfer to excel and display 12/01/2008

that's my problem now...

[chilly_charly]

---

snta1806 a écrit:

if my date; 01/12/2008 (dd/mm/yyyy) the problem will be coming...

it's will transfer to excel and display 12/01/2008

that's my problem now...

---

Have you tried the solution proposed in the other thread (see above - that solved definitively the date problem for me) ? What's the issue with this solution your specific case ? Can you post a short sample VI that shows the problem ?