View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
 
Posts: n/a
Default Very weird error

On Mon, 21 Nov 2005 12:23:02 -0800, "Stian"
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