Globally Changing Format Of Negative Currency Numbers In C#?

Oct 22, 2010

We have a large ASP.NET MVC project where all numbers output to the screen are formatted as currency (i.e. ToString("c"). However, negative numbers are showing up with ()'s. For example:

decimal d = -8.88m;
Console.WriteLine(d.ToString("c"));
//outputs $(8.88)

This is a bit annoying to our users, particularly since there are in textboxes. We have a few thousand places where we send currency fields to the screen like this, so we'd love a way to change the formatting globally. Is there one? All the methods I've seen indicate that you have to create a new formatter, similar to this:

string curCulture = System.Threading.Thread.CurrentThread.CurrentCulture.ToString();
System.Globalization.NumberFormatInfo currencyFormat =
new System.Globalization.CultureInfo(curCulture).NumberFormat;
currencyFormat.CurrencyNegativePattern = 1;

We'd prefer not to change all of our ToString("c") methods ... is there a better way? My first thought was to just change our locale to Australia, but realized the date formatting would be screwed up.

View 2 Replies


Similar Messages:

Currency Format String Besides "C" / Convert Negative Amounts?

Sep 8, 2010

Is there another currency format string besides "C"? "C" seems to convert negative amounts like you'd see on a bank statement (e.g. $-10.67 shows up as ($10.67)). The guy here at work doesn't like to see .00 at the end of money so in a gridview I wrote for him I was just dropped the last three characters after I converted the values to .ToString("C"), but one negative value in the bunch breaks that logic.

View 7 Replies

Data Controls :: Add Comma To Large Numbers And Display It In Currency Format

Jan 24, 2016

With reference to the following thread: URL....I have problem applying the same concept to gridview EditItemTemplate. Is there a way i can add comma to large numbers and display it in currency format like exemple below:

Textbox3=Textbox1 * Textbox2

Textbox3= 1,000.00

Textbox3 should happen OnTextChanged and the above controls are in Gridview edit mode.

View 1 Replies

Web Forms :: Automatically Add Comma To Large Numbers And Display In Currency Format

Jan 24, 2016

How can i calculate the sum of two textboxes(Textbox1 and Textbox2) and then add comma with .00 to another textbox(Textbox3). Example say Textbox1 = 2 and Textbox2 = 500

Textbox3=Textbox1 * Textbox2

Textbox3= 1,000.00

Note: Textbox3 should happen onkeyup ...

View 1 Replies

Web Forms :: Cannot Display Negative Numbers

Oct 19, 2010

I have the following issue where I cannot seem to display a negative number and the result seems to stay on zero.

The code is as follows:

[code]...

In my code iNumber1 = 108 and iNumber2=27 however when the result is divided again by 108 the answer seems to stay on 108. I tried using doubles but with no luck.

View 3 Replies

Crystal Reports :: How To Change Negative Numbers

Sep 7, 2010

I have negative numbers in my report and I wish to display them with a "<" sign.

View 5 Replies

Forms Data Controls :: Put Bracket For Negative Numbers?

Aug 6, 2010

I have a gridview that calculate net balance by taking deposit - withdraw. So when the withdraw is more than the deposit, it will result in a negative value, how do I detect that and replace the minus sign with bracket?

[code]....

View 10 Replies

C# - Changing ScriptManager's Attribute Globally?

Mar 30, 2011

In each projects we have several pages which have the following tag

<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>

Now we would like to change those to (about 80% of Pages)

<asp:ScriptManager ID="ScriptManager1" EnableScriptGlobalization="true" EnableScriptLocalization="true" runat="server">
</asp:ScriptManager>

Is there any way to do that from a single source like Web.config or Global.asax or using any HTTPHandler.

View 3 Replies

CompareValidator Currency Check Does Not Work With French Formatted Numbers?

Oct 8, 2010

I have a salary TextBox and an associated CompareValidator, which is setup as follows:

<asp:CompareValidator ... Operator="DataTypeCheck" Type="Currency" />

I fill the TextBox with a formatted string out of the database:

txtSalary.Text = myObject.Salary.ToString("N2")

When a user accesses the page using a French culture (such as fr-ca), the ToString method will put 80 000,00 in the textbox, which is fine.However, any number with a space in it causes the validator to fail, which is not fine. Is there any way to make the CompareValidator work properly with non-US formatted numbers?

View 1 Replies

C# - Validate US Currency With This Format $123.45?

Jul 6, 2010

I have one one web page which one one textbox for receiving the dollar value. My requirement is the user should insert the digit following by a $ sysmbol. And the second requirement is the user has the permission to insert only like this $123.45. Before the decimal point it should not exceed three digits and after the decimal point it should not exceed two digits.

View 3 Replies

Currency Format Not Working?

Jul 8, 2010

I'm not sure why my label text is not formatting to currency.

Here is my code:

[Code]....

It shows the sum result but in decimal format like 123.123, I want to show it like $123,123.00

View 2 Replies

C# Sometimes Currency Format Does Not Work?

Jul 28, 2010

It seems that sometimes the currency format does not work:

string Amount = "11123.45";
Literal2.Text = string.Format("{0:c}", Amount);
reads 11123.45
it should be:
$11,123.45

View 2 Replies

Web Forms :: How To Format Currency In A Textbox

Jan 26, 2010

how to format currency in a textbox? i don't want to user ajax maskextender..

View 5 Replies

Web Forms :: How To Format String To Currency

Feb 2, 2010

I have the following get and sets

I am trying to do it so that my number is displayed in a currency format and British £.

However, I get an error in my GET when trying to run my website and it says ... 'Input string was not in a correct format'.

Can anyone see where I might be going wrong?

[Code]....

View 7 Replies

C# - Displays Currency Value In US Culture Format?

Mar 18, 2011

How can I displays currency value in US culture format like $5,123,456.55. I know that I can do it using ToString method but don't know how?

View 2 Replies

Unable To Format Label.Text To Currency

Dec 30, 2010

I am having trouble formating label.text to currency in below statement:

Label5.Text = Convert.ToString(tsum * (3) * (.9m));
Label5.Text = Convert.ToString.Format("{0:c}", (tsum * (3) * (.9m)) );

error says ToString is a method not valid in given context.

View 5 Replies

C# - Using BoundField.DataFormatString To Format Currency Data?

Mar 29, 2011

I have a gridview that I am populating with data for the folks in accounting and they want me to format currency values so that they display without $'s, with commas separating digits and with negative numbers surrounded by ( )

e.g.:

12345.67 = 12,345.67
-12345.67 = (12,345.67)

I have found lots of examples around the interwebs that get me close but there is either no ( ) around negatives or there is a $ included.

View 3 Replies

Currency Format String Not Going To 2 Decimal Places?

Nov 11, 2010

I'm not getting a trailing zero on currency values and I have no idea why not. This is my code:

[Code]....

Yet this is what is showing up on the screen:

$18.7

Very aggrevating...It should not be doing this as I understand it.

View 4 Replies

Format A Label Currency - Syntax Is Not Working

Dec 9, 2010

I have a label in a gridview which does a calc and works great however it does not format currency as expected. The label takes the bound value of QTY and multiples with the bound value of PRICE that is wrapped in a function to get a gross price.

[Code]...

View 9 Replies

Localization :: Currency Format In Datalist, Label?

May 8, 2010

I can displays the number value as currency format but I wanna show it as Euro, English sterling and USd !

<asp:Label runat="server" ID="UnitPriceLabel" Text='<%# Eval("UnitPrice", "{0:C}") %>' />

I used the above code ! What can I do ?

View 6 Replies

Web Forms :: Format Label.Text As Currency?

Mar 18, 2011

I was just wondering how to format my label.text result as currency.

View 2 Replies

VS 2010 - Custom Currency / Decimal Format

Dec 17, 2012

I have searched and found various methods for formatting as a string decimal values but cant fine one which covers all my needs. I have to display a decimal value (a financial money figure) i.e. 2500.75

However I do not require any leading currency symbol such as $ or £ and the main point I am struggling with is that when the value has no value after the decimal do not display zeros. I thought

Code:
.ToString(".##")

was meeting my requirements initiall but then realized if someone put the value 7.4 in it was displayed as 7.4 when it should be displayed as 7.40.

I have also tried

Code:
<%# String.Format("{0:0.##}", DataBinder.Eval(Container.DataItem, "Amount"))%>

But this seems to have no effect at all.

And in addition

Code:
<%# String.Format("{0:0.C}", DataBinder.Eval(Container.DataItem, "Amount"))%>

Always displays the two decimals even when zero.

View 1 Replies

VS 2010 Datarow - Display With Currency Format

Mar 22, 2012

I use to display the amount using this code

Code:
Label1.Text = dr["Amount"].ToString();

But how can it display it with currency format? or like this: "$100.00"?

View 7 Replies

Web Forms :: Regex Formatting Raw Number To Currency Format?

Aug 16, 2010

I am trying to take user supplied raw numeric values (these numbers dont have decimal point) and correctly format the values to their correct currency display.


eg: user enters 2341 the routine would use regex to format it to 23.41

I cant find a way to do this. What I have tried is this:

[Code]....

It doesnt work.... sNjunk always comes out 299 instead of 2.99.Anyone out there that can help me with this? or point me in the right direction?

View 6 Replies

AJAX :: Displaying Currency With MaskedEditExtender In Correct Format

Dec 1, 2010

I am using ASP.NET3.5. I have used MaskedEditExtender for currency purpose. when iam insering data into table it is accepting correct figures. while reading the same figures from database,I am displaying the figured in another textbox. (for second textbox i have used MaskedEditExtender) but it is displaying in that text box wrongly. suppose x=100 am reading this value from database and displaying x value in edit mode.but it is displaying 1.00. means it is taking last 2 digits as decimal points. how can I show in correct format?

View 5 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved