On Tue, 2006-04-25 at 16:13 +0200, [EMAIL PROTECTED] wrote: > Hallo CPH, > > Op 25 Apr 06 schreef CPHennessy aan [email protected]: > > >> >> I'm running OO 2.02. > >> >> Language settings are: > >> >> user interface English (USA) > >> >> locale setting Dutch (NL) > >> >> decimal separator key (not marked) > >> >> default currency EUR Dutch (NL) > >> >> default language for docs Dutch (NL) > >> CP> Tools -> Options -> Language Settings. > >> That gives me the settings as I showed them in my original message. > >> Where else do you think I got them from? ;) Could you please tell me > >> how I can persuade Calc to accept the full stop as decimal separator > >> in stead of the comma? I prefer to enter dates in the Dutch way > >> [mm/dd/yyyy], but am used to entering the decimal separator as full > >> stop, not as a comma. > > CP> So what if you select the option ? > CP> (it may be a bug in the text string) > > I had not thought of that :) But it makes no difference. Might it be > time to report a bug? > > Groetjes, > > Hans.
It should be possible, using the language selector, within cell styles. Open up the stylist(F11), it will normally open with cell styles having the focus. Right click on "Default", select "New" and enter a suitable name for this new style. Select the numbers tab, choose a suitable language for using decimal point and set any other associated formatting you may require. Click OK to save your new style. Now if you apply this style to a cell or range of cells a decimal point should be displayed, if you apply the default style a decimal comma will be displayed and your dates will have the Dutch format. You can generate a number of different styles and easily switch between them. For example if you had to present your finished document with comma's, you would simply apply the default style to the respective cells. If you now save this document(containing your new styles) as a template and set it as the default template, your settings will be available to all new documents. HTH Barrie --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
