Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Currency to text | Excel Discussion (Misc queries) | |||
Currency to Text | Excel Worksheet Functions | |||
Currency Becomes Text ? | Excel Discussion (Misc queries) | |||
Currency to Text | Excel Discussion (Misc queries) | |||
Text to Currency | Excel Discussion (Misc queries) |