Other Currency in the TEXT Function

[redmonski]

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?

 

[Peo Sjoblom]

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]

I'm trying to use SGD for currency in the TEXT Function, is there a
corresponding character code for SGD? Maybe pounds and dollars are working
because they have a corresponding character code.