English date format and compatibilty with others Excel Language

[Guest]

Hi,

We are using English Excel, and others users using French or German Excel.
When fomulates which are unsing date format are created in Excel File,
others users using French or German Excel can't use the Formulate, because
the format of the date are note the same.

Exemple : In English "mmyyyy" in French "mmaaaa" or German "ttjjjj"

How can we avoid this kind of problem, or how can we automate the conversion
of the formulates...
May be it is a system parameters...

Thanks.

 

[Niek Otten]

Use this UDF:

Function FormatString(a As Range) As String
FormatString = a.NumberFormatLocal
End Function

It returns the formatstring from a cell in the local format. You can use that instead of a textstring in functions like TEXT()

I have a multilingual version of Excel which has a few flaws so I couldn' test it.
Please let us know if it works.

--
Kind regards,

Niek Otten

| Hi,
|
| We are using English Excel, and others users using French or German Excel.
| When fomulates which are unsing date format are created in Excel File,
| others users using French or German Excel can't use the Formulate, because
| the format of the date are note the same.
|
| Exemple : In English "mmyyyy" in French "mmaaaa" or German "ttjjjj"
|
| How can we avoid this kind of problem, or how can we automate the conversion
| of the formulates...
| May be it is a system parameters...
|
| Thanks.