Thursday, July 9, 2009

The Joys of MS Excel

Today I added export-to-csv functionality to the app I'm working on (so people can dump data to Excel and do whatever the hell they want with it).

Spent about twenty minutes trying to figure out why certain fields in Excel were showing up as "########" instead of "2009/10/11" (for example).

Apparently Excel does this when a cell without spaces is deemed to be too long. Weird.

1 comment:

  1. I knew this. Took me awhile to figure out. But I did :)

    ReplyDelete