On Monday 31 December 2007 08:49:10 [EMAIL PROTECTED] wrote:
> Hi all,
>
> I am migrating *.txt data from one system to another. There are a lot of
> columns with numbers in them (e.g. "1.80")
> When I open it with Calc, it converts it to a date (01.01.80). 1.62
> becomes 01.01.62, and 2.12 becomes 02.12.07
>
> How do I shut this off?! I hate automation! I dropped excel, because it
> is worse, it was automating everything, like dropping leading zeros, etc.
>
> With the txt or csv import I ensure all fields are defined as "text" and
> not as "standard", but Calc displays it as dates despite my definition.
>
> TIA
>
> :-)
>
> Al
>
>
> I wish all a Prosperous New Year - a quick help will start mine as
> prosperous al well.
Is there a way to define these columns as numbers when you import the
file?
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
