Re: [libreoffice-users] Currency conversion/display in calc
Hi :) I think the usual way is to avoid typing in the $ sign and just let the cell formatting put that in front for you. Regards from Tom :) From: Steve Edmonds steve.edmo...@ptglobal.com To: users@global.libreoffice.org Sent: Saturday, 9 March 2013, 6:00 Subject: [libreoffice-users] Currency conversion/display in calc Hi. If I type or paste $2,441.99 into a cell in calc (3.6) it is left aligned. If I right click format cell it states number-general. If I divide it by 2 I get #value! How do I get LO to recognise this as a number. I found a long winded way, format it as currency and remove the ' that LO puts in front. Steve -- 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] Currency conversion/display in calc
Hi Steve, I only have 4.0.1.2 installed, but my guess is that with the comma in there, or possibly the dollar sign, or maybe both, when you are pasting it, calc thinks it is text and not a number. That causes the left alignment and not being dividable since text can't be divided. Don On 03/09/2013 01:00 AM, Steve Edmonds wrote: Hi. If I type or paste $2,441.99 into a cell in calc (3.6) it is left aligned. If I right click format cell it states number-general. If I divide it by 2 I get #value! How do I get LO to recognise this as a number. I found a long winded way, format it as currency and remove the ' that LO puts in front. Steve -- *~~* Don C. Myers Manager, Farm and Rural Property Division e-PRO Certified by the National Association of Realtors Don's Cell Phone: 814-571-9518, Don's Home Phone: 814-422-8111 Don's E-mail: donmy...@myersfarm.com mailto:donmy...@myersfarm.com *RE/MAX Centre Realty **1375 Martin Street, State College, PA 16803* Office Phone: 814-231-8200 Fax: 814-231-8220 Visit the Farm and Rural Property Division web site at _www.CentralPaRuralProperty.com http://www.CentralPaRuralProperty.com/ _ Visit the RE/MAX Centre Realty main web site at _www.StateCollegeHomeSales.com http://www.statecollegehomesales.com/ _ View Don's Farm Web Site at www.myersfarm.com http://www.myersfarm.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] Currency conversion/display in calc
On 03/09/2013 01:00 AM, Steve Edmonds wrote: Hi. If I type or paste $2,441.99 into a cell in calc (3.6) it is left aligned. If I right click format cell it states number-general. If I divide it by 2 I get #value! How do I get LO to recognise this as a number. I found a long winded way, format it as currency and remove the ' that LO puts in front. Steve I use LO 3.6.5.2 from the LO website. When I write $2,441.99, Calc recognizes it as a currency. When I copy it and then paste it into a cell, I get the Import Options dialog. At its bottom is the Options and a box that should be checked any time the data contains special numbers such as dates, currencies, etc. So I have 2 ways to paste currency: click the box in the Option section, or paste special. However, if you have gotten you version of LO from a repository rather than from the LO website, your version may not have the Import Options dialog. --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] Currency conversion/display in calc
On 2013-03-10 01:23, Johnny Rosenberg wrote: 2013/3/9 Steve Edmonds steve.edmo...@ptglobal.com: Hi. If I type or paste $2,441.99 into a cell in calc (3.6) it is left aligned. If I right click format cell it states number-general. If I divide it by 2 I get #value! How do I get LO to recognise this as a number. I found a long winded way, format it as currency and remove the ' that LO puts in front. Steve I think a macro could do that for you and I was even thinking of writing one, but if it should be useful no matter what locale settings you have, the macro needs to know things like decimal- and thousands separator (for example in my country we use space for thousands separator and comma for decimal separator, which is quite different from yours). I am sure it's possible but still searching… Johnny Rosenberg Thanks Johnny I thought easy enough with regexp but noticed that there are instructions on how to do it in excel so thought LO might too. Steve -- 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] Currency conversion/display in calc
Hi :) You can always try to use Paste Special Shift Ctrl V and choose unformatted text. I'm not sure if that will strip the ' off the front or the marks from around it but it';s got to be worth a try when pasting stuff from websites. Regards from Tom :) From: Steve Edmonds steve.edmo...@ptglobal.com To: Dan Lewis elderdanle...@gmail.com Cc: users@global.libreoffice.org Sent: Saturday, 9 March 2013, 21:41 Subject: Re: [libreoffice-users] Currency conversion/display in calc On 2013-03-10 07:12, Dan Lewis wrote: On 03/09/2013 01:00 AM, Steve Edmonds wrote: Hi. If I type or paste $2,441.99 into a cell in calc (3.6) it is left aligned. If I right click format cell it states number-general. If I divide it by 2 I get #value! How do I get LO to recognise this as a number. I found a long winded way, format it as currency and remove the ' that LO puts in front. Steve I use LO 3.6.5.2 from the LO website. When I write $2,441.99, Calc recognizes it as a currency. When I copy it and then paste it into a cell, I get the Import Options dialog. At its bottom is the Options and a box that should be checked any time the data contains special numbers such as dates, currencies, etc. So I have 2 ways to paste currency: click the box in the Option section, or paste special. However, if you have gotten you version of LO from a repository rather than from the LO website, your version may not have the Import Options dialog. --Dan Thanks for the help. I may have figured it. If I copy and paste from a plain text document it works fine. If I copy and paste from another source, say a web page I have a problem. If I copy and paste into writer, and then copy again into calc I am fine. I think I have to do this to copy html tables from the web to calc. Cheers, Steve -- 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