Re: [libreoffice-users] Re: Is it possible to show cell value with text

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.clegg@nailsea.net>
To: Dan Lewis <elderdanlewis@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 <elderdanlewis@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%2Bhelp@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+help@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+help@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