Did it again… sent it privately. Sorry again, then. Here's to the list:
---------- Forwarded message ---------- From: Johnny Rosenberg <[email protected]> Date: 2013/3/9 Subject: Re: [libreoffice-users] Currency conversion/display in calc To: Tom Davies <[email protected]> 2013/3/9 Tom Davies <[email protected]>: > 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. Yes, of course, but didn't he say he also want to paste? What about pasting a whole column from somewhere? Johnny Rosenberg > Regards from > Tom :) > > > > > >>________________________________ >> From: Steve Edmonds <[email protected]> >>To: [email protected] >>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: [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 > -- 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
