asked on

FormatCurrency

I am running a site on 2 different servers. One is Windows 2000 Server and the other is Windows 2000 Advanced Server. I have the currency set to Sterling Pounds # in Control Panel, Regional Options but both show Dollars $ when I use FormatCurrency.

Any ideas guys?

Cheers

Dave

TTom

Hmmm. I wonder. Is this being done on the server side or on the client side? When I did this, I could make the results change, depending upon where the writing was being done.

Tom

daveamour

ASKER

The writing is being done on the server using the VBScript FormatCurrency Function so its not a client side issue. Besides I have tried this clientside in the UK and in Canada.

Cheers

Dave

TTom

FWIW, I thought that might be the case, but I figured I would toss it out.

Have you tried the parameters of the FormatCurrency Function? When I did this, I used

response.write FormatCurrency(1000,2,-2,-2,-2)

(I think the last parameter is "use regional settings", but I may be wrong.)

If I set my Regional Currency Symbol to something other than $, it worked just fine. However, if I used client side script, the same page wrote differently on different machines.

Good luck!

Tom

weesiong

daveamour,

Using LCID()

original = SetLocale("de")
myvalue = CCur(GermanNumber.value)
original = SetLocale("en-gb")
USNumber.value = FormatCurrency(myvalue)

Regards,
Wee Siong

ASKER CERTIFIED SOLUTION

rxolotl

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

daveamour

ASKER

This seems to be the best workaround, couldn't get any of the others to work.

Thanks everyone

Dave

rxolotl

Thanks =D