Date changes

[Steve Reilly]

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?
> 
> 
29/5/2009	EVENING	6TH	CE-304	Geotechnical Engg.	CIVL	A0619	A0619

1/6/2009	EVENING	6TH	CE-306	Irrigation Engineering-I	CIVL	A0620	A0620


using jaunty and same ooo build here and this is what shows up for 363
and 363.  if you dont want the date formatted the euro way, (day before
month) then you can change it to whatever you want in the cell format
menu.  right click and highlight all the dates, right click, format,
choose date format and pick the way you want it to appear.  is that what
you were asking?


steve