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