• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 718
  • Last Modified:

Currency Format ASP VBScript --

Hi Guys,

Please help, When I call -

<%=FormatCurrency(RsLocalRetainerHighRetainer.Fields.Item("RetainerValue").Value,0)%>

I want to get £25,000

But Instead I'm getting -

?25,000

Appreciate the help - thank you
0
garethtnash
Asked:
garethtnash
3 Solutions
 
EyalCommented:
try...
<%=Server.HTMLEncode(FormatCurrency(RsLocalRetainerHighRetainer.Fields.Item("RetainerValue").Value,0))%>
0
 
Chris BottomleyCommented:
I guess it depends on the server locale:

You could prepend it with:

<%SetLocale("en-gb")%>

Chris
0
 
pegasysCommented:
This will also depend on the installed languages on the server. If they don't support the £ symbol you will get that.

Try view the page source, go to where the £25000 is (or is supposed to be) and see how it shows up in the raw HTML.

That would give you a good clue as to what is going on.

Failing that, you can use HTML code for this:

&#163;

That is the £ symbol. Format the number as decimal and tack that on the beginning.

Another thing you could try, is tacking on this header:

<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

0
 
garethtnashAuthor Commented:
thank you
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now