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