Pradeep Srinivas wrote: > > On Monday 08 January 2007 02:42, Alex Zachopoulos wrote (regarding [users] > Numbers in cells imported as dates-not just numbers): >> I've just used Graphisoft's ArchiCAD 10 to export a tab separated >> file with dimension data for all doors and windows in a building >> project. In Finder, I changed the .tab to .csv and used OOo 2.0 to >> open the file, which took me to the Text Import panel, where I >> specified all columns to be 'Standard'. In the Preview pane, I can >> see all data showing properly as numbers. For example, for "Door sill >> height" and "Door head height" I get the values as e.g. "0.0000" and >> "3.0000". >> >> I click on OK, and when the file is finished opening I see that the >> columns are not exactly fine: Zero values still show as "0.0000", but >> non-zero values have turned into dates: 3.0000 becomes "01/03/00". >> Every time. >> >> Any advice? Many thanks, as always. > Alex, > > I tried something similar (no real data, only created a small file with > some > text/data combination) - no issues with the import. > > While I cannot say, offhand, why you are having this problem, I could take > a > look at your input file if you would care to share the same. If you DO > want > to share the input CSV file, **please, please** do NOT post to the list, > but > send it to my id alone. > > -- > Pradeep Srinivas > Bangalore, India > >
The error more than likely relates to your locale settings. Instead of "standard", try "US English" as the format. Regards. -- View this message in context: http://www.nabble.com/Numbers-in-cells-imported-as-dates-not-just-numbers-tf2936182.html#a8211569 Sent from the openoffice - users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]