Very weird error

Thanks for helping out Ron, that solved my problem.

Is there anything the developer can do to make this work no matter what
regional settings a user has?

On Mon, 21 Nov 2005 12:23:02 -0800, "Stian" <Stian@discussions.microsoft.com>
wrote:

>Thanks for helping out Ron, that solved my problem.
>
>Is there anything the developer can do to make this work no matter what
>regional settings a user has?

I don't know enough about that sort of thing to answer.

Perhaps he could avoid the TEXT function by formatting the cell appropriately.
Or perhaps he could detect the locality using VBA and change various formulas
accordingly.


--ron