Format Currency in ASP?

jason

Is there an easy way to format a number into a currency display style eg:
$100,000.

I have this set in my Access database on the field but my asp produces:
100000

Is there perhaps a formatCurrency command or something like that in ASP?

Thanks
Jason

Jul 19 '05 #1

Subscribe Post Reply

15643

Curt_C [MVP]

Oddly enough
FormatCurrency()

:}

--
----------------------------------------------------------
Curt Christianson (Software_AT_Darkfalz.Com)
Owner/Lead Designer, DF-Software
http://www.Darkfalz.com
---------------------------------------------------------
...Offering free scripts & code snippits for everyone...
---------------------------------------------------------
"jason" <ja***@catamaranco.com> wrote in message
news:el**************@tk2msftngp13.phx.gbl...

Is there an easy way to format a number into a currency display style eg:
$100,000.

I have this set in my Access database on the field but my asp produces:
100000

Is there perhaps a formatCurrency command or something like that in ASP?

Thanks
Jason

Jul 19 '05 #2

Alan

Yes.

Alan

"jason" <ja***@catamaranco.com> wrote in message
news:el**************@tk2msftngp13.phx.gbl...

Is there an easy way to format a number into a currency display style eg:
$100,000.

I have this set in my Access database on the field but my asp produces:
100000

Is there perhaps a formatCurrency command or something like that in ASP?

Thanks
Jason

Jul 19 '05 #3

jason

Thanks :)
"Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
news:#s**************@tk2msftngp13.phx.gbl...

Oddly enough
FormatCurrency()

:}

--
----------------------------------------------------------
Curt Christianson (Software_AT_Darkfalz.Com)
Owner/Lead Designer, DF-Software
http://www.Darkfalz.com
---------------------------------------------------------
..Offering free scripts & code snippits for everyone...
---------------------------------------------------------
"jason" <ja***@catamaranco.com> wrote in message
news:el**************@tk2msftngp13.phx.gbl...
Is there an easy way to format a number into a currency display style eg: $100,000.

I have this set in my Access database on the field but my asp produces:
100000

Is there perhaps a formatCurrency command or something like that in ASP?

Thanks
Jason

Jul 19 '05 #4

by: Bill Stanard | last post by:

I have had no success using the format function as follows (the two lines of code run one after the other): 'displays a running total of lblAmtdue.Caption 'contents in txtTotal.Text...

Visual Basic 4 / 5 / 6

Currency Format Blues

by: Dalan | last post by:

This should not be an issue, but it is. I'm sure that someone knows what little piece of code is needed too persuade Access 97 to include a currency format for labels (Avery, mailing type). Have...

Microsoft Access / VBA

UnionQry Currency format

by: DD | last post by:

I have a UnionQry that is run from StatementsI and StatementP. the Due and Paid colunms are currency and show the $ however when i union the two the currency format has gone. Any help please...

Microsoft Access / VBA

Regional Settings Currency Format

by: Bob Dydd | last post by:

Hi Everbody Question Changing the regional settings ie. from UK to US AUS etc, Access retains the original currency format that the application was created in. So if an mdb that is written...

Microsoft Access / VBA

No decimal currency format

by: Gerry Abbott | last post by:

Hi All. How can i put a zero decimal for my currency into my format statement, == & ", for " & & " days. Cost " & Format(,"Currency") which is the data source for a textbox on a report

Microsoft Access / VBA

Control format property in OnFormat event

by: Nigel C | last post by:

Hi, I am going round in circles... I am trying to produce a report based upon the information gathered into a temp table. Each column (stored as a text field) in the table holds weekly...

Microsoft Access / VBA

How to translate number with currency format to pure number

by: zlf | last post by:

1¡¢Here is a number. double nu = 123 2¡¢Format it with 3¡¢The result is "$123" I want to ask how to deformat "$123" to 123 Thx (Currency symbol is not restricted to '$')

C# / C Sharp

Binding, Format, Parse...Not able to edit

by: Slonocode | last post by:

I have some textboxes bound to an access db. I wanted to format the textboxes that displayed currency and date info so I did the following: Dim WithEvents oBidAmt As Binding oBidAmt = New...

Visual Basic .NET

Format Function Not Working with Currency

by: crferguson | last post by:

Hello all! I'm having the oddest issue trying to format a numeric string as currency without decimals. For instance... strSalary = "120000.56" strSalary = Format(strSalary, "$#,##0") 'this...

.NET Framework

UK to USA Currency format

by: Ian | last post by:

I have an Access 2000 database written in the UK, this database has many fields set to Currency, I now want to move this database over to a user in the USA but my Currency fields still show the UK...

Microsoft Access / VBA

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Similar topics