Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Other Programming > VBScript
| Search | Today's Posts | Mark Forums Read
VBScript For questions and discussions related to VBScript.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VBScript section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old May 12th, 2006, 09:17 AM
Banned
Points: 1,561, Level: 16
Points: 1,561, Level: 16 Points: 1,561, Level: 16 Points: 1,561, Level: 16
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2005
Location: , , .
Posts: 317
Thanks: 0
Thanked 0 Times in 0 Posts
Default FormatCurrency Function Question

I'm new to this, so please bear with me. I'm trying to use the FormatCurrency Function to format a number located in a SQL Server 2k DB table. But I'm having a problem in defining the rules for the number. Basically, the number in the DB is "180792" (without quotes), and I want it transfered to "$1807.92". But my setup of this method is returning "$180,792".

Here's more details on what I'm using, and what I'm trying to do:

ORIGINAL DB VALUE:
180792

CURRENT CODE:
Dim strNumber As String = Trim(rsQuery("Number").Value.ToString)
strNumber = (FormatCurrency(strNumber,0))

CURRENT RESULT:
$180,792

WANTED RESULT:
$1,807.92

I hope that someone can help me out with this one. I'm just not sure if this method has too many limitations that I can't use, or if I'm just not adding another few steps. Any and all help is appreciated. Thanks.

KWilliams
Reply With Quote


Similar Threads
Thread Thread Starter Forum Replies Last Post
ASP.NET 1.1 to 2.0 FormatCurrency Problem kwilliams ASP.NET 2.0 Basics 1 October 25th, 2006 10:28 AM
Another Document ( ) Function Question bonekrusher XSLT 2 August 4th, 2006 10:45 AM
Question on the ARRAY function savoym VBScript 6 May 31st, 2005 06:53 AM
Function Question stu9820 ASP.NET 1.0 and 1.1 Professional 9 December 4th, 2003 12:29 PM
Shell Function Question SerranoG Access VBA 4 November 12th, 2003 07:57 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.