From memory, it's sufficient to pre-format the spreadsheet cells as
text. I'd suggest creating a cell style with text format (F11). You
then paste as "unformatted text" using either Paste-Special or the
dropdown arrow on the paste icon.
It that does not work, you may have to alter the default style of your
document to text (F11 again, right-click on "Default" then select
"Modify"). Paste as "unformatted text". The result will be that all
your data will be text.
This is from a post on the forum:
"Using a decent text-editor for csv-lists is a good idea (one program,
frequently mentioned here is "csved" for Windows).
When I open a list like this one:
"19.05.",19,"0,098093712748072","http://www.openoffice.org",,19
File>Open shows a dialog with preview. I can select the first column in
the preview and declare this column as text."
HTH. This is an example of software out-smarting itself.
Sonia Carey wrote:
I am copying a table from a text document to spreadsheet. One of the
fields in the table contains text in the format eg. 5.1.5. When pasting
into the spreadsheet, oo.org converts this text to dates. How do I stop
oo.org from doing this?
Send instant messages to your online friends http://au.messenger.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
