get a $ instead of a £

[Andrew Thomas]

My results show a $ instead of a £

here is the code

<%= FormatCurrency((rs_products.Fields.Item("product_premier_price").Value), 2, -2, -2, -2) %>

Am i doing something wrong in the code? I've also checked the regional settings on my computer and they are set to UK setting

and ideas

Andy

[korkus2000]

That is based on a regional setting on the server. What does the currency tab on the regional setting say? I would hardcode the output or do a replace for a work around.

[JuDDer]

You could try adding one of these to the top of your page to set the Locale ID:

<% Session.LCID = 2057 %>

Or

<%@LCID=2057%>

[Andrew Thomas]

Korkus, both setting on the server and my local machine had United Kingdom setting, and currency set to £.

However

I tried what Judder said and put <% Session.LCID = 2057 %> into the code and it works fine, the only problem is that i havent a clue how this bit od code works :)

If you get time to explain it id be gratefull,

and thankyou both

Andy

[korkus2000]

Here is some info on LCID
[msdn.microsoft.com...]