Dates in Excel

[don H. Lee]

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

 

[Niek Otten]

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.