On 05/24/2009 02:24 PM, NoOp wrote: > On 05/24/2009 10:13 AM, H.S.Rai wrote: >> http://www.goldentemplephotos.com/datesheet_new.xls has row no 362, 363 when >> opened using OpenOffice 3.0.1 (on Ubuntu 9.04) build 9379 shown as: >> >> 29/5/2009 EVENING 6TH CE-304 Geotechnical Engg. CIVL A0619 06/01/2009 >> EVENING 6TH CE-306 Irrigation Engineering-I CIVL A0620 >> >> While Google Doc as well MSExcell shows 01/06/2009 for row no. 363 (which is >> correct), that mean 1st of June is shown as 6th of Jan. Such error is there >> for many rows in same spreadsheet. >> >> Where is problem? With excel spreadsheet or with OpenOffice? >> > > Look at the 'A' cell values: > 360: 30/6/2009 > 361: '27/5/2009 > 362: '29/5/2009 > 363: 01/06/2009 > > In Excel: > 360: Format is 'Date' '*3/14/1001' > 361: Format is 'Custom' 'd-mmm' > 362: Format is 'Custom' 'd-mmm' > 363: Format is 'Date' '*3/14/1001' > > The problem is in Excel. Fix your inconsistent cell formats in Excel. > OOo is interpreting the data correctly... GIGO.
Sorry, forgot to mention; the easiest way to spot which cells have screwed up formating is to simply select column's A & B and format the cells enmass for 'Date 31. December 1999' or 'December 31, 1999'. You'll then easily see which convert to that format & which one's do not. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
