LibreOffice

how to use calc

Asked by Allan White

I have a spreadsheet showing a number of shares and the price paid etc. When I entered the money paid for shares, I clicked on the icon at the top of the page so all the sums would be shown with a dollar sign in front. Now I want to add these collumns and find the total but every time I try the answer either shows a $- or $000.

Can someone explain to me in easy terms how I can add the whole column or a part of the column and receive a correct and accurate answer so I know how much they cost. Someone told me to format them as accounting in microsoft excell but OO does not have this option.

Thank you , Allan

Question information

Language:
English Edit question
Status:
Answered
For:
LibreOffice Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Whiteboard:
libreoffice should be a better match
Revision history for this message
Allan White (moele) said : 		#1

I have not received an answer yet. I may be posting the question on the wrong site. If I am, can somebody please tell me where to go to find out about OO calc.

It seems a straight forward question and should be easy to answer but it is driving me nuts.

Revision history for this message
Dan Watkins (oddbloke) said : 		#2

Hi Allan,

This part of Launchpad is specifically for questions about Bazaar, the
version control system; I'm afraid I wouldn't know where it would be
best to look for advice about OO Calc.

Regards,

Dan

On 29 May 2014 23:56, Allan White <email address hidden> wrote:
> Question #249311 on Bazaar changed:
> https://answers.launchpad.net/bzr/+question/249311
>
> Allan White gave more information on the question:
> I have not received an answer yet. I may be posting the question on the
> wrong site. If I am, can somebody please tell me where to go to find out
> about OO calc.
>
> It seems a straight forward question and should be easy to answer but it
> is driving me nuts.
>
> --
> You received this question notification because you are an answer
> contact for Bazaar.

Revision history for this message
Dan Watkins (oddbloke) said : 		#3

I'm down 22 pounds in 2 months, thank you for whoever told me about
this! http://huff.to/w9k8JC

Can you help with this problem?

Provide an answer of your own, or ask Allan White for more information if necessary.

To post a message you must log in.