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

" wrote in message
...
| 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.