in reply to Excel, Drop Down Menu, and Perl

With Excel, yes there is a way to do this, something to do with column format I believe. I would think that Spreadsheet::WriteExcel would be capable of performing the same function, but you should probably read the docs to find out.

If it doesn't pan out for you, you may be able to use OLE to convince Excel to do what you want.