You don't add the currency sign to the money figures column, you highlight the relevant column, then go to format cells, going to the numbers tab, and there take the currency option. A box will allow you to choose the currency, and another currency will allow you to display it. In my case I choose £.
Hope this helps On 23 Mar 2012 at 14:10, Manfred Schmid wrote: Send reply to: [email protected] From: Manfred Schmid <[email protected]> Subject: Import of csv file from my bank Date sent: Fri, 23 Mar 2012 14:10:30 +0100 To: [email protected] > i got an csv list from my bank (stadtsparkasse). the import with oo > looks quite well. but when i try to format my money colum, for example > add the € sign nothing is changed. when i want to add 2 values of this > colum i.e = g2+g3 i got an error #value. > > i imported wit unicode (utf-8) > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] For > additional commands, e-mail: [email protected] > Niall Martin Phone 0131 4678468 Please reply to: niall<at>rndmartin.cix.co.uk --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
