Hi Anthony Thanks for passing on the reply which has sorted out my problem.
Lawyers in South Africa are not fatcats like in the USA . Cheers Peter ----- Original Message ----- From: "Anthony Chilco" <[EMAIL PROTECTED]> To: <[email protected]>; <[EMAIL PROTECTED]> Sent: Wednesday, May 18, 2005 6:50 PM Subject: Re: [users] Numbers in Spreadsheets > > Hi Peter, > As you're not subscribed to the list you may not have seen > this reply: > > p.s. support from this list is volunteer based and usually > free, but for lawyers, there's an $180 per hour, one hour > minimum charge..... :-) just kidding. > tc > > > Martin Ringo wrote: > > Peter, > > > > Highlight the cells you want to reformat into the traditional X,XXX.XX > > format. Then go to (click on) the format iten of the menu and pick > > cells. You should see that the language is English (South Africa) or > > maybe Afrikaans. In several of the langauge versions the format is > > the X.XXX,XX form. Change the language to something like English > > (USA) or English (UK) and then pick the numerical format in the > > window. And you should be good. > > > > Marty > > > > > > On 5/18/05, Peter Spence <[EMAIL PROTECTED]> wrote: > > > >>My name is Peter Spence an attorney (lawyer) in a small town in South Africa my e-mail is [EMAIL PROTECTED] > >> > >>I am now using Open Office 1.1.4 and recently received a cd to update my version and this changed the way my spreadsheets are formatted. The numbers used to be 13,500.50 and are now reflected as 13.500,00. > >>The difference is that the decimal point now is a comma and not a full stop (or period). The latter is easier for me to use as on the number pads the . is more easily to access than the , which is not on the number pads but with the letters. > >> > >>I presume the format can be changed but do not know how to do so. > >> > >>Thanks for the good software. > >> > >>Regards > >>Peter Spence > >> > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > ________ Information from NOD32 ________ > This message was checked by NOD32 Antivirus System for Linux Mail Server. > http://www.nod32.com > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
