On Sun, 19 Feb 2006 21:02:32 -0500, Ron Rosenfeld <ronrosenfeld@nospam.org>
wrote:

>On Mon, 20 Feb 2006 09:42:22 +0800, budgie <me@privacy.net> wrote:
>
>>Using Win98SE, I have regional settingsto show date as day-month-year style (as
>>is normal here). However, Excel 97 refuses to adopt this style, and I can't see
>>any way to get the required format - certainly nothing in Tools->Options or
>>Tools->Customise addresses this.
>>
>>Can anyone advise me how to get this to behave?
>
>"refuses to adopt this style" could mean a number of different things.
>
>In Excel-speak, format has to do with how a cell's contents is displayed.
>
>Style includes a number of formatting options, but I doubt you'd want to format
>a number as a date.
>
>Some people use this terminology when they have problems entering data.
>
>
>To format the cell to your liking, at the top of the main menu bar you should
>see a selection labeled "Format".
>
>If you click on that you should see an option labeled "Cells"
>
>Check Number on the tabs at the top of the dialog box that opens; then select
>date and see if your desired format is present.

It isn't - that's the point. While I have selected day-month-year in regional
settings, all the format *types* presented in the Format->Cell->Number->Date are
month-date(-year) types. Excel does not offer the required type of date
formatting.

>If you mean something else by your statement, you'll need to be more specific.

I really thought the above was sufficiently clear and specific.