This thread will grow (well, in terms of my questions, but also hopefully with answers).
I have a very basic knowledge of spreadsheet use.
I generally use OpenOffice Calc, but I have Microsoft Excel, too, if that comes in handier.
Question #1: When I import a spreadsheet, how do I ask it to eliminate an apostrophe before each date reference?
It is invisible in the spreadsheet view, but the dates won't sort. When I clicked on one date cell, the bar at the top showed me there is a secret apostrophe before each date. When I remove that manually, the dates respond to my antics. This will be hundreds of lines per year, though. Is there a way I can ask the whole spreadsheet to not have a secret apostrophe in the date field, either during import or after?