SYLK File Format Error in Excel

Here's one you'll like.

1) Create a simple file that looks exactly like this:

ID, name, Address
123,Sally, 123 Fake Street

Make sure the CASE is accurate

2) Save the file as test.csv (or any csv file), so that it will open as a csv file in Excel.

3) Try and open it in Excel. If you followed the instructions correctly, it will not open. Instead you will get an error something like:

"SYLK: File format is not valid"

4) Now, open the file in Notepad. Change ID to id, or change it to DI if you prefer.

5) Save, and try and open again in Excel.

Why does this happen?

According to Microsoft, "This problem occurs when you open a text file or CSV file and the first two characters of the file are the uppercase letters "I" and "D"

here's the full text of the article:
http://support.microsoft.com/kb/323626/

This is one of those things you may never encounter, but if you do when you're on a project and you can just say "Oh that old thing? ha!" and fix it, people will think that in emergencies, you walk on water. Rather than just passing it....