Information générale
Catégorie:
Codage, syntaxe et commandes
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement