Hi experts,

I've been struggling with following problem for a couple of days now. We have thousands of report templates created in German excel, that contain the TEXT function. Let's say we have function like this =TEXT(JETZT();"tt/MM/jjjj" ... this equals =TEXT(NOW(),"dd/MM/yyyy" on English.

When I open the file in English Excel, I receive #VALUE error as Excel cannot parse the format provided by German ...but it's kinda logical

There's nothing easier, then retyping it manually, however, the format might vary. In 2 templates I opened I found for example following
=TEXT(JETZT();"tt/MM/jjjj"
=TEXT(JETZT();"MM/tt/jj"
=TEXT(JETZT();"jjjj/tt/MM"

So generally I would need some code, or hint on how to go on in Generally converting one format provider [German] into another....might be VBA, C#, VB.NET .. whatever, it just needs to be able to reformat one locale into another.

Thank you very much for your help in advance