Marvelstiftelsen
Teacher
lifetime member
Posts: 277
My Collection
|
- Posted: September 28, 2021 4:32:28 am
- Hi,
When I export my piles into CSV format, the format for Issue Date is the same for all comics - but for those with a May and October date. In other words, when the CSV file is imported into Excel, all the dates in the Issue Date colum looks the same, except for the ones in May and October.
As an example January 1990 comes out in Excel as '1990-01-01' May 1990 comes out in Excel as 'May 1990'
Any ideas why this might be, and how to correct it?
|
AmZoMBiE
Wise Beyond the Years
moderator
Location: Michigan
Posts: 6822
My Collection
|
|
dough boy
I have no life
moderator
lifetime member Location: Kansas City
Posts: 12057
My Collection
|
- Posted: September 29, 2021 4:36:04 am
- Look at the raw data in CSV. It likely looks the same. It is just Excel not understanding how to interpret things and you have to help it format.
Favorite Quote: "You're not just some guy in a bat costume are you? ARE YOU FREAKING KIDDING ME?! - Justice League #1, 2011" Hunting for (mainly reprints/variants) - Please help! - See My Profile
|
Marvelstiftelsen
Teacher
lifetime member
Posts: 277
My Collection
|
- Posted: September 29, 2021 1:25:28 pm
- Mystery solved... did some digging with some help of a person who is an Excel wiz... as it turns out, as I have a Swedish version of Excel, May and October are the only two months that is spelled differently when appreviated to the first three letters. October is Okt and not Oct. May is Maj not May.
So Excel simply got confused and transposed it differently.
False alarm
|
AmZoMBiE
Wise Beyond the Years
moderator
Location: Michigan
Posts: 6822
My Collection
|
|
dough boy
I have no life
moderator
lifetime member Location: Kansas City
Posts: 12057
My Collection
|
- Posted: September 29, 2021 9:09:45 pm
- I will say I didn't expect that.
Favorite Quote: "You're not just some guy in a bat costume are you? ARE YOU FREAKING KIDDING ME?! - Justice League #1, 2011" Hunting for (mainly reprints/variants) - Please help! - See My Profile
|