Excel: After opening the spreadsheet, select the date column.
Select Data|Text to columns In Step 2, drag all the arrows off the ruler. In Step 3, select date for the format. Click finish. Voila. Rich Shockney RS Marketing -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Fred Ennis Sent: Tuesday, October 23, 2001 11:41 AM To: [EMAIL PROTECTED] Subject: useable date format in .csv downloads? HI! Maybe I don't know enough about spreadsheets, but has anyone found a quick and easy way to make the spreadsheet (Excel or Quattro) recognize the date in the OpenSRS .csv files you can download for domain management? If I could sort by expiry date locally (and then use that as part of my accounting) I would be elated. Do people get elated any more? thanks! fred
