[RBG7-L] - Re: Date Conversion - Gateway

[gary.wend]

Check to see if the Excel document is saved as a worksheet or a workbook.  To work properly, it needs to be saved as a workbook.  Rbase does a much better job of importing the correct data for dates, if it is in the workbook format.        ----- Original Message ----- From: John Docherty To: RBG7-L Mailing List Sent: Sunday, February 27, 2005 3:55 AM Subject: [RBG7-L] - Date Conversion - Gateway I have imported an Excel spreadsheet containing dates, (format dd/mm/yyyy), but end up with integers in the date column, as per the spreadsheet ‘format’ for storing dates (ie 38385 etc). My question is, is there a simple way to change these to a date recognised by Rbase ? (I have tried importing these with the format set to match the spreadsheet format but end up with nulls.)  Have I missed the obvious solution here ?   Thank you.   Regards,   John Docherty -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.306 / Virus Database: 266.5.0 - Release Date: 25/02/2005