Hi Newsgroup

I have a big problem handling dates in excel or formatting them the right
way.

Using VBA there is no Problem but when I using formatted fields the trouble
begins.

My tool is used in several languages (german, french, italian) and when I
use localized formatting of date fields like "DD.MM.JJJJ" (for german) and
using this on french system i receive an error.

Now I made a work around and replacing (Text-replace in VBA) the formatting
with the localized format, but this isn't very nice.

Any idea how to handle this?

Thanks alot

D. H. Lee

You don't tell how you use the format.
Is it in a TEXT() function in the worksheet? Are you entering a formula in
the worksheet through VBA?
Anyway, use the Locale option in the Formatting dialog. If you record a
macro while doing it, you can see how to do it from VBA as well.
With a literal, so a format string between qotes, you'll never get automatic
translation between languages.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"don H. Lee" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi Newsgroup
>
> I have a big problem handling dates in excel or formatting them the right
> way.
>
> Using VBA there is no Problem but when I using formatted fields the
> trouble begins.
>
> My tool is used in several languages (german, french, italian) and when I
> use localized formatting of date fields like "DD.MM.JJJJ" (for german) and
> using this on french system i receive an error.
>
> Now I made a work around and replacing (Text-replace in VBA) the
> formatting with the localized format, but this isn't very nice.
>
> Any idea how to handle this?
>
> Thanks alot
>
> D. H. Lee
>
>