At 22:43 24/05/2009 +0530, 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.
One extra thing I didn't mention before: there is an easy way in Calc
to show the difference between the two sorts of data you have in
column A. Go to View | Value Highlighting (or Ctrl+F8). The text
entries - the majority of your values - will remain black, but the
values entered as dates - with which you are having the problem and
which are numbers - will turn blue. This way you will more easily
see the problem and perhaps be able to decide on your best way forward.
I trust this (also) helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
