Shopping at LEGO or Amazon?
Please use our links: LEGO.com
As an Amazon Associate we earn from qualifying purchases.
Importing Database to Excel issues
Apologies if this has been answered before. I just spent the last week updating my collection into the Brickset database. Then I attempted to export it to Excel.
I found an unusual anomaly that I do not know how to fix...
Any set with a 4 digit number came out as a date under the SetNumber column:
eg: 4195 appeared as Jan-95
3 digit number and 5 digit numbers were no problem:
eg: 628 appeared as 628-1 and 10194 appeared as 10194-1
I'd like to get the 4 digit numbers reading correctly...
Any Excel experts out there that could help?
The 5 digit numbers appear as 10194-1 in the input box when the cell is highlighted
The 3 digit numbers also appear similarly: 628-1
The 4 digit numbers have an extra bit that is probably causing the issue: 4195-01-01
Many thanks in advance!
Shopping at LEGO.com or Amazon?
Please use our links: LEGO.com • Amazon
Recent discussions •