[LUNI] Open Office question

[Janine Starykowicz]

Not a Linux question, but it is open source, please help.

I'm trying to convert some rich text charts that I was emailed to 
tab-delimited text files.  If I copy them into calc, the columns hold, I 
can export fine from there.

The problem is the formatting of some of the data.  I have dollar fields 
that need to keep the dollar signs and commas ($20,000).  This converts 
to 20000.  I have another field that is odds: 8-1, 5-2 etc.  These get 
calculated.  Is there any way to force text formatting on these columns 
aside from manually entering ' at the beginning of each cell?

Thanks!
Janine