The & concatenates text strings whereas + tries to add them and fails!
On 12 November 2012 04:28, Viral Orpe <viral.o...@yahoo.com> wrote: > Hi John, > > Checked your reply on list-archives :) > Somehow must have missed on 6th Nov when it first appeared. > > Please, what is the & stand for? > Dave_ had asked the question with a + > > So, I guess this is some standard way of doing things(name?) with slightly > diff syntax. > > I have never known it can be done that way - text and formula together in > a cell. > I have always used adjacent cells - one with the text part and another > with the formula. > > Any pointers would be great. > > Thanks, > Regards, > Viral Orpe :) > --------------------------------------------------------------------------------------------------- > > Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz > Memory : 4GB, DDR3 > OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) > > LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302) > > --------------------------------------------------------------------------------------------------- > > ------------------------------ > *From:* John Clegg <john.cl...@nailsea.net> > *To:* Dan Lewis <elderdanle...@gmail.com> > *Cc:* "users@global.libreoffice.org" <users@global.libreoffice.org> > *Sent:* Sunday, November 11, 2012 9:59 PM > *Subject:* Re: [libreoffice-users] Re: Is it possible to show cell value > with text > > This was a thread from 5th November which I answered to the group. He > thanked me but got fooled by the stupid group reply settings. > > > On 11 November 2012 16:24, Dan Lewis <elderdanle...@gmail.com> wrote: > > > On 11/11/2012 11:03 AM, dave_ wrote: > > > >> Thanks for the solution. > >> > >> > >> > >> -- > >> View this message in context: http://nabble.** > >> documentfoundation.org/Is-it-**possible-to-show-cell-value-** > >> with-text-tp4016842p4018036.**html< > http://nabble.documentfoundation.org/Is-it-possible-to-show-cell-value-with-text-tp4016842p4018036.html > > > > >> Sent from the Users mailing list archive at Nabble.com<http://nabble.com/> > . > >> > > How can we give you a solution when you have not yet given us the > > problem? It appears that you are using Calc. But what to you mean by show > > cell value"? Where is the text located? Are you referring to a cell > > containing twenty-seven rather than 27 for example? Or perhaps ten > november > > two thousand twelve instead of 10 Nov 2012 or Nov 10, 2012? > > Please be more specific. > > > > --Dan > > > > -- > > For unsubscribe instructions e-mail to: users+help@global.libreoffice.** > > org <users%2bh...@global.libreoffice.org> > > Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** > > unsubscribe/< > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/> > > Posting guidelines + more: http://wiki.**documentfoundation.org/** > > Netiquette <http://wiki.documentfoundation.org/Netiquette> > > List archive: http://listarchives.**libreoffice.org/global/users/< > http://listarchives.libreoffice.org/global/users/> > > > All messages sent to this list will be publicly archived and cannot be > > deleted > > > > > > -- > For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > > > > -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted