On Tue, 2006-06-13 at 12:18 +1000, Keith Bainbridge wrote: > G'day Ross > > > Of Course - that's why it worked a coupl of times while I was 'allowed' to > change the regional settings; but my settings broke another program, so no > can do................ > > > On 6/13/06, Ross Johnson <[EMAIL PROTECTED]> wrote: > > > > Keith Bainbridge wrote: > > > > >G'day Folks > > > > > >How can I get calc to save the date format as dMMMyyyy when saving as > > >either .csv or .dbf - the 2 formats that my plain text information > > manager > > >recognises. > > > > > > > > For .csv, dates are formatted according to your locale setting (in > > Tools->Options->...) and there appears to be no way around this. You can > > try finding a locale that happens to format dates in your preferred > > format, or it may be necessary to convert the date into a text string - > > using text formatted cells - to do what you want. > > > > Ross > >
Use cell styles. Press F11 to open Styles and Formatting dialog, right click on the default cell style and select new. Under the Organiser tab, enter a suitable name. Now select the Numbers tab, choose an appropriate language(English(UK) will provide the format you require), select date as Category and the format you require. Click OK to save your settings. To apply the cell style, select the relative cells and double-click the cell style you created Barrie --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
