Re: [libreoffice-users] Re: Is it possible to show cell value with text
Thanks Dan, Link/Guides look good :) Regards, Viral Orpe From: Dan Lewis elderdanle...@gmail.com To: users@global.libreoffice.org Sent: Wednesday, November 14, 2012 8:29 AM Subject: Re: [libreoffice-users] Re: Is it possible to show cell value with text http://wiki.documentfoundation.org/Documentation/Publications Download the Calc Guide from this link. It may help. --Dan On 11/13/2012 08:06 PM, Viral Orpe wrote: Hi Johnny, May be I should go through Calc documents/ How to use Calc or something similar! I have used Excel/Calc in a hands on approach - using the drop down menu one gets after clicking the = sign for entering a formula, a generous use of F1, exploring the menus/ icons on tool-bar and of course, Google. So, (now it seems, obviously) I do not know the full capabilities of either software. I may not have needed/ used/ or thought possible many aspects/ functionalities of these applications that are standard practice for most users! And, hence the confusion. Got to get back to the basics :) Thanks anyways, 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) Processor : Intel (R) Pentium(R) III Memory : 256MB SDRAM (!?), 20GB IDE OS : Vector Linux - Kernel (???) LibreOffice : Yet to try.. ! --- From: Johnny Rosenberg gurus.knu...@gmail.com To: LibreOffice Användare users@global.libreoffice.org Sent: Tuesday, November 13, 2012 10:14 PM Subject: Re: [libreoffice-users] Re: Is it possible to show cell value with text 2012/11/13 Viral Orpe viral.o...@yahoo.com: Thanks Johnny, Season's Greetings!! (Today we are celebrating Diwali Festival and New Year here - India) I would like to know what is this language used to talk to Calc? And would appreciate any pointers to any literature, guides etc. I know C and have worked with formulas - this combination is new to me. I am not sure what you are asking. So far in this thread we have only talked about cell formulas, as far as I have seen. Those are the same as those in Excel, at least most of them. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Thanks, Regards, Viral Orpe :) From: Johnny Rosenberg gurus.knu...@gmail.com To: Viral Orpe viral.o...@yahoo.com Sent: Monday, November 12, 2012 11:42 PM Subject: Re: [libreoffice-users] Re: Is it possible to show cell value with text 2012/11/12 Viral Orpe viral.o...@yahoo.com: 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? =A1 B1 is the same as =CONCATENATE(A1;B1) Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ 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.**htmlhttp://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
Re: [libreoffice-users] Re: Is it possible to show cell value with text
2012/11/13 Viral Orpe viral.o...@yahoo.com: Thanks Johnny, Season's Greetings!! (Today we are celebrating Diwali Festival and New Year here - India) I would like to know what is this language used to talk to Calc? And would appreciate any pointers to any literature, guides etc. I know C and have worked with formulas - this combination is new to me. I am not sure what you are asking. So far in this thread we have only talked about cell formulas, as far as I have seen. Those are the same as those in Excel, at least most of them. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Thanks, Regards, Viral Orpe :) From: Johnny Rosenberg gurus.knu...@gmail.com To: Viral Orpe viral.o...@yahoo.com Sent: Monday, November 12, 2012 11:42 PM Subject: Re: [libreoffice-users] Re: Is it possible to show cell value with text 2012/11/12 Viral Orpe viral.o...@yahoo.com: 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? =A1 B1 is the same as =CONCATENATE(A1;B1) Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ 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.**htmlhttp://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 -- 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
Re: [libreoffice-users] Re: Is it possible to show cell value with text
Hi Johnny, May be I should go through Calc documents/ How to use Calc or something similar! I have used Excel/Calc in a hands on approach - using the drop down menu one gets after clicking the = sign for entering a formula, a generous use of F1, exploring the menus/ icons on tool-bar and of course, Google. So, (now it seems, obviously) I do not know the full capabilities of either software. I may not have needed/ used/ or thought possible many aspects/ functionalities of these applications that are standard practice for most users! And, hence the confusion. Got to get back to the basics :) Thanks anyways, 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) Processor : Intel (R) Pentium(R) III Memory : 256MB SDRAM (!?), 20GB IDE OS : Vector Linux - Kernel (???) LibreOffice : Yet to try.. ! --- From: Johnny Rosenberg gurus.knu...@gmail.com To: LibreOffice Användare users@global.libreoffice.org Sent: Tuesday, November 13, 2012 10:14 PM Subject: Re: [libreoffice-users] Re: Is it possible to show cell value with text 2012/11/13 Viral Orpe viral.o...@yahoo.com: Thanks Johnny, Season's Greetings!! (Today we are celebrating Diwali Festival and New Year here - India) I would like to know what is this language used to talk to Calc? And would appreciate any pointers to any literature, guides etc. I know C and have worked with formulas - this combination is new to me. I am not sure what you are asking. So far in this thread we have only talked about cell formulas, as far as I have seen. Those are the same as those in Excel, at least most of them. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Thanks, Regards, Viral Orpe :) From: Johnny Rosenberg gurus.knu...@gmail.com To: Viral Orpe viral.o...@yahoo.com Sent: Monday, November 12, 2012 11:42 PM Subject: Re: [libreoffice-users] Re: Is it possible to show cell value with text 2012/11/12 Viral Orpe viral.o...@yahoo.com: 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? =A1 B1 is the same as =CONCATENATE(A1;B1) Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ 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.**htmlhttp://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-**
Re: [libreoffice-users] Re: Is it possible to show cell value with text
http://wiki.documentfoundation.org/Documentation/Publications Download the Calc Guide from this link. It may help. --Dan On 11/13/2012 08:06 PM, Viral Orpe wrote: Hi Johnny, May be I should go through Calc documents/ How to use Calc or something similar! I have used Excel/Calc in a hands on approach - using the drop down menu one gets after clicking the = sign for entering a formula, a generous use of F1, exploring the menus/ icons on tool-bar and of course, Google. So, (now it seems, obviously) I do not know the full capabilities of either software. I may not have needed/ used/ or thought possible many aspects/ functionalities of these applications that are standard practice for most users! And, hence the confusion. Got to get back to the basics :) Thanks anyways, 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) Processor : Intel (R) Pentium(R) III Memory : 256MB SDRAM (!?), 20GB IDE OS : Vector Linux - Kernel (???) LibreOffice : Yet to try.. ! --- From: Johnny Rosenberg gurus.knu...@gmail.com To: LibreOffice Användare users@global.libreoffice.org Sent: Tuesday, November 13, 2012 10:14 PM Subject: Re: [libreoffice-users] Re: Is it possible to show cell value with text 2012/11/13 Viral Orpe viral.o...@yahoo.com: Thanks Johnny, Season's Greetings!! (Today we are celebrating Diwali Festival and New Year here - India) I would like to know what is this language used to talk to Calc? And would appreciate any pointers to any literature, guides etc. I know C and have worked with formulas - this combination is new to me. I am not sure what you are asking. So far in this thread we have only talked about cell formulas, as far as I have seen. Those are the same as those in Excel, at least most of them. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Thanks, Regards, Viral Orpe :) From: Johnny Rosenberg gurus.knu...@gmail.com To: Viral Orpe viral.o...@yahoo.com Sent: Monday, November 12, 2012 11:42 PM Subject: Re: [libreoffice-users] Re: Is it possible to show cell value with text 2012/11/12 Viral Orpe viral.o...@yahoo.com: 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? =A1 B1 is the same as =CONCATENATE(A1;B1) Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ 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.**htmlhttp://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?
[libreoffice-users] Re: Is it possible to show cell value with text
Thanks for the solution. -- View this message in context: 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. -- 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
Re: [libreoffice-users] Re: Is it possible to show cell value with text
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 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+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
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.**htmlhttp://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
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.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.**htmlhttp://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
Re: [libreoffice-users] Re: Is it possible to show cell value with text
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.comhttp://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