Solved

FormatCurrency

Posted on 2001-06-29
7
559 Views
Last Modified: 2007-12-19
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
0
Comment
Question by:daveamour
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 9

Expert Comment

by:TTom
ID: 6239370
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
0
 
LVL 19

Author Comment

by:daveamour
ID: 6239389
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
0
 
LVL 9

Expert Comment

by:TTom
ID: 6239486
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

0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 7

Expert Comment

by:weesiong
ID: 6240184
daveamour,

Using LCID()

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

Regards,
Wee Siong
0
 
LVL 1

Accepted Solution

by:
rxolotl earned 25 total points
ID: 6244952
I think that you can make something like
fNum = FormatNumber(yourNum, 2)
fNum= "$" + fNum
0
 
LVL 19

Author Comment

by:daveamour
ID: 6250085
This seems to be the best workaround, couldn't get any of the others to work.

Thanks everyone

Dave
0
 
LVL 1

Expert Comment

by:rxolotl
ID: 6250357
Thanks =D
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now