Hi!
I hope one of you can help me with the following problem:
I'm working with a program to analyse and tag photos, so in this program I can change the metadata that comes with the photo's. This metadata can be exported to Excel by saving it as a separated by commas (.csv) file. I can import this file in Excel, change the settings so a comma means new column. So far, all works very well. However, my photoanalysing program stores the date as yyyy:mm:dd. Excel interpret this input as a time. So, date 2013:05:11 becomes 23-3-1900 21:05:11, even before I was able to change any settings to tell Excell that yyyy:mm:dd means yyyy/mm/dd. I can see, when I go over the cell with the date with my mouse, that the raw data is correct, it says 2013:05:11. I tried all settings in the 'home' menu and I made custom settings, but because Excel already interpret this date as time, I never get the right date. Is there a way to tell Excel that it should use the raw data and that it should not interpret it already?
I hope my story is clear enough and I hope even more that someone can help me
Thank you very much in advance!
Bookmarks