Hans, You could frig it with a custom format for the US sheet of say

[=1000000]###\,###\,##0.00;[=1000]###\,##0.00;###0.00

I can't test it with my setup, but should work.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Hans Knudsen" wrote in message
...
Hello
Let's say I wish to use a formula something like the following:
=IF(A1="DK", 10.000.000, 10,000,000)

That is, I want to have a number formatted according to Danish
respectively US standard depending upon the contents of A1. Danish
standard is period as thousand separator. I wonder if it might be possible
to do this by a user defined function. I am aware that I
can change the number handling in the Tools, Options, International dialog
box, but then it has effect for the whole workbook. I
need to use Danish number format in one sheet of a workbook and US number
format in another sheet.

Hans Knudsen