On Fri, 2005-02-25 at 15:13 +1000, Naomi Kramer wrote:
Hrmmm... OK, one more attempt and I leave you to the experts :-) Two options occur to me (they're both a little messy) -
- During import (if you select Insert -> Sheet from File) you can format each column of data before it's imported. If there are a lot of columns, doubtless this isn't really an option either.
This is probably the best way to do it. <tip author="G. Roderick Singleton" subject="Entering text in Calc"
category="Calc">
When values in a files are converted to dates or numbers but should not
be, you can
override this by setting the column to text using the fields entry.
Simply select the column and then the type from the Column type
dropdown.
</tip>
That was it!
Thanks to all for very useful suggestions. The method that worked best for me was:
In the File Import dialog, select each column that you want to keep as text and change the column type from "Standard" to "Text". Your text will then import unaltered.
thanks, Greg
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
