Other Currency in the TEXT Function
 

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?

Other Currency in the TEXT Function
 

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?

Other Currency in the TEXT Function
 

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.

"Peo Sjoblom" wrote:

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?