Date fromat from CSV

[flyingkiwi08]

I have a program which exports files in CSV format. I am using open Office to open these but when i do it automatically changes the date format. In Excel the date displays as 6.2007 but in OO it changes it to 6.2 - I have tried and searched but cannot seem to find a way to make it display the correct year - even 6.2007 or 6.07 etc would work - but all I can do is 6.2.

Has anyone else come accross this?

Any ideas how to fix it so a date shows?

Thanks

[keme]

What does the date look like in the CSV file?

Are the "international" settings (specifically date formats) the same in the two apps?

[flyingkiwi08]

In the CSV file the date is 6.2007

Settings in Excel are Australia and in OO the same.

Here is the file I am trying to open:

http://download.yousendit.com/F1C3A02C3C24E1D2

If you open with MS Excel the dates are right but OO somehow messes them up during conversion.

EDIT: I feel like such dumb ass - it was the decimal places - if i exoand them I get 6.2007 but as default it reads 6.2.

[Dave]

You just beat me to it, since that was my first instinctive solution. I was stalled in seeing it as a decimal value, not a date, and had to quit first since I will not go to unknown sites for downloads or whatever with cookies activated. Why do you call it a date?

David.

[kingfisher]

In the dialogue you get when opening the file (nominated as "text .CSV"), you can choose a format for that column. I suggest 'Text'.