Re: [libreoffice-users] Formula and text in same cell?

2017-11-21 Thread Remy Gauthier
Greetings, You can also create a custom number format to place text around the value if you only want to show a single value. For example, you can assign this number format to a cell: "Jane bought "0" apples." If you then set the value of the cell to 2, the cell will display: Jane bought 2 apples.

Re: [libreoffice-users] Formula and text in same cell?

2017-11-20 Thread Joe Conner
Would insert -> comment be of help? On 11/20/2017 09:47 PM, Brian Barker wrote: At 20:04 20/11/2017 -0500, Dotty Carl wrote: In a cell, let's say A1, ... I don't see that matters ... ... there's a formula such as =DayNum(Z1, Z3). I'd like to also put text in the same cell. So what do

Re: [libreoffice-users] Formula and text in same cell?

2017-11-20 Thread Brian Barker
At 20:04 20/11/2017 -0500, Dotty Carl wrote: In a cell, let's say A1, ... I don't see that matters ... ... there's a formula such as =DayNum(Z1, Z3). I'd like to also put text in the same cell. So what do you want to have displayed in that cell? Any formula defines what is displayed. What

[libreoffice-users] Formula and text in same cell?

2017-11-20 Thread .
Hello all,In a cell,let's say A1, there's a formula such as =DayNum(Z1, Z3).  I'd like to also put text in the same cell. How can this be done?Thanks,Carl -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?