What do you mean by "it won't work"? This works for me
using pounds for instance

=TEXT(A1,"£#,##0.00")


--


Regards,


Peo Sjoblom



"redmonski" wrote in message
...
How do I use other currency in the TEXT Function other than the $
currency?
If I insert other currency in the arguments by typing it, it won't work.
Is
there any other way of inserting other currency in the arguments of the
TEXT
Function other than by typing it?