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. >> > 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