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. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
