[LUNI] Open Office question

[Mark Stuart Burge]

Hi Janine


>
> 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.
You can select the column that should have $ and format the whole column 
as currency (there is a toolbar icon that looks like     )
>   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? 
If you select the columns you want left alone, then go to Format Cell 
and choose TEXT  (it is represented with the @ format code)  then paste 
without formatting, the cells should hold the text format and leave the 
- as a - and not a minus