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 <[email protected]> To: Dan Lewis <[email protected]> Cc: "[email protected]" <[email protected]> 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 <[email protected]> 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: [email protected].** > org <users%[email protected]> > 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: [email protected] 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: [email protected] 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
