Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 12 Sep 2019 01:01:18 +0200How do I format a cell to accept the number zero as the first entryhttps://ask.libreoffice.org/en/question/208319/how-do-i-format-a-cell-to-accept-the-number-zero-as-the-first-entry/When I fill the cell 0787 and move on to the next cell. The number 0787 deletes the beginning zero. How do I format the cell to accept the number as entered?
Thanks
cofabmanThu, 12 Sep 2019 01:01:18 +0200https://ask.libreoffice.org/en/question/208319/Insert a given number in the middle of text.https://ask.libreoffice.org/en/question/95446/insert-a-given-number-in-the-middle-of-text/Hi everyone!
I'm wondering if I can write "Amount in N transactions" so that N would be J3, for example. Where if I write 10 in J3 I end up with "Amount in 10 transactions".
The first thing I've tried was "Amount in J3 transactions" or "Amount in =J3 transactions", and as theres the possibility of my problem being a simple sintax trick I'm appealing to y'all.
Note that J3 not necessarily will be 10, my point is for it to work for any given real number.
And, if its possible, how would it be to make "Amount in N+1 transactions"?DaanikWed, 17 May 2017 22:58:56 +0200https://ask.libreoffice.org/en/question/95446/