I received a question/problem, and I have no knowledge of the different language sets
in Excel, and how they deal with dates. Could someone help me out with this? Any ideas
on a resolution?
4) Localisation. I am using a french version of excel 97. In this version
the date is typed (dd/month/aaaa). Oddly even if type the date (or pick up
from drop list), it doesn't fill properly in the "SEND" sheet, only the
month typed in french appears.
Thanks,
Mike Mulka
--- In mepbmlist@y..., "Aaruman" <aaruman@o...> wrote:
I received a question/problem, and I have no knowledge
of the different language sets in Excel, and how they
deal with dates. Could someone help me out with this? Any ideas
on a resolution?>4) Localisation. I am using a french version of excel 97.
> In this version the date is typed (dd/month/aaaa).
> Oddly even if type the date (or pick up from drop list),
> it doesn't fill properly in the "SEND" sheet, only the
>month typed in french appears.
One way might be to just remove year from the date if possible. We
don't really have games which has a year between turns, do we? 
Like dates in norwegian Excel is dd.mm.åååå
Øystein
I think the automatic cell formating works better on this as the format
strings...
AFAIK the auto format converts the date in your local machine format you
selected in Windows.
I've done this, because the German format is TT.MM.JJJJ
\Rene.
-----Ursprüngliche Nachricht-----
Von: otvedten [mailto:oysteint@ifi.uio.no]
Gesendet: Sonntag, 31. März 2002 23:04
An: mepbmlist@yahoogroups.com
Betreff: [mepbmlist] Re: Non-English dates
> >4) Localisation. I am using a french version of excel 97.
> > In this version the date is typed (dd/month/aaaa).
> > Oddly even if type the date (or pick up from drop list),
> > it doesn't fill properly in the "SEND" sheet, only the
> >month typed in french appears.
>One way might be to just remove year from the date if possible. We
don't really have games which has a year between turns, do we?Like dates in norwegian Excel is dd.mm.åååå