On Thursday March 16 2006 11:29 am, livid wrote:
> This message is in response to an email from CPHennessy who replied to a
> query from me when he said
>
> "Hi David,
> What happens if you just try to open the Excel file with OpenOffice.org
> ? That was in response to my email saying
>
> > "I am a new user who previously worked with Excel. Is there any way
> > that I can copy a financial report from Excel into a new
> > OpenOffice.org Calc sheet?
> >
> > I tried using copy and paste but that did not work.
>
> I had no luck when I opened Calc and then tried
> File >Open >C:\Program Files\Microsoft Office\Office\Excel.exe
>
> At that point it did not permit me to enter the file name that I hoped
> to open within Calc. Instead I was presented with a completely dull grey
> screen apart from the top blue band with the OOo icon at top left.
>
> If I may ask one further query. Is it possible to set 2 decimal places
> in a spreadsheet? Searching in Help leaves me thinking it cannot be
> done at this stage. If that is currently the situation can it be
> considered for the next update, and what would be the appropriate
> procedure for asking for it to be considered?
>
> Later
>
> I have at last managed to get the details into a Calc spreadsheet, but I
> had to resort to copying just 2 columns at a time and to repeat that 5
> more times for a 12 month document. Further more by copying and pasting,
> Calc accepted a 2 decimal place display, BUT after I saved the
> spreadsheet and re-opened it the 2 place display had disappeared. Can
> someone kindly advise me the correct way of sending such a query to the
> correct program section for future queries.
>
> David Anderson
For any column that you want all entries to have 2 decimal places do
this:
1) Right click the column label (A,B,C, etc.) and select Format Cells.
2) Select the category your want (number, currency, etc.).
3) Select the number of decimal places you want.
4) Click OK.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
