Hi Christof,

Because I wrote the UDF a while back it had escaped me to mention : we
tried that at the time even though it was not mentioned in the
documentation. All you get, on our system at least, is a number which
uses the SET CURRENCY symbol allright, but where the formatting that you
require is completely ignored : e.g. no commas for the thousands,
a decimal point and digits after it, etc.... (Output required £2,222 for a
value of 2222, or £2,222,222 for a value of 2222222).

Try it and you'll see what I mean.

Any other suggestions ?

Thanks.
Michel.

==================== Original message follows ====================

>Hi Michel,
>
>>We would always get the dollar sign rather
>>than the British Pound sign.
>
>Because you are mixing up a function code and a format code. OK, it's not properly documented in the help file, but the correct function call would be:
>
>? Transform(2222,"@$9,999,999")
>
>Christof