How to make thousand separator and decimals in textbox

Jim Tat

I'd like to input numbers in a textbox and format it with a thousand separator and two decimals.

I've tried the Masked Edit with a lot of different masks, but I just can't get it to work.

And I tried this code:

Thread.CurrentThread.CurrentCulture = new CultureInfo("fr-FR");
double text = double.Parse(txt.Text);
txt.Text = text.ToString("#,##");

But when I insert in the textbox for example 2500 I got 02 500 while I want 2 500.
Any suggestions ?
Thank you.

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

theLizard10y ago
I am a bit confused, what exactly do you want?
You say, "But when I insert in the textbox for example 2500 I got 02 500 while I want 2 500."
By your example "text.ToString("#,##");" you are asking for a result looking more like this 2,50 then say you want a result like 2 500
You also say "and two decimals." I see No decimals in the number (2500) you have used as your example!
If you want 2 decimals, the format for that would be "#,##0.00" it also appears that using a format, for example of "# ##" using your number (2500) as the example, results in a formatted string like "25 00", not what you want I expect.
So to get the proper answer to your question, you need to provide what it is that you want exactly otherwise, the formatting function work as they are supposed to.
Madhanmohan Devarajan10y ago
Jim,
To capture the key press and changed events in WinForms are even more easier than Web. Here is the link that deals with similar kind of your issue.
http://stackoverflow.com/questions/19215989/textbox-for-price-cash-currency-on-c-sharp
Jim Tat10y ago
Ah :( I am using Winform ...
Madhanmohan Devarajan10y ago
Its just a asp:textbox binded to JQuery function. In ASP.Net C# page you need to add the asp.net textbox and can perform some action onblur of asp textbox. Please find the attached text file to get the code.
Jim Tat10y ago
I can put it in C# ?
Madhanmohan Devarajan10y ago
Jim,
Here is the original JQuery function called while typing the text in textbox. Have highlighted the "," portion. Please modify it with space. Here is the source of the JQuery file.
http://bendewey.com/code/formatcurrency/jquery.formatCurrency-1.4.0.js
==================================================
$.formatCurrency = {};
$.formatCurrency.regions = [];
// default Region is en
$.formatCurrency.regions[''] = {
symbol: '$',
positiveFormat: '%s%n',
negativeFormat: '(%s%n)',
decimalSymbol: '.',
digitGroupSymbol: ',',
groupDigits: true
};
Jim Tat10y ago
How can we put it in C# code please ? the Jquery plug-in?
Jim Tat10y ago
Hi,
I need to put a space separator instead of the comma...
Madhanmohan Devarajan10y ago
Jim,
Here is the solution you are exactly asking for.
http://bendewey.com/code/formatcurrency/demo/format_as_you_type.html
JQuery Plug-in
https://code.google.com/archive/p/jquery-formatcurrency/
Jim Tat10y ago
Hi,
I found something interesting but I have a problem when I put some numbers in the textbox, the cursor comes always to the left ...
Here is the code:
doubletext=double.Parse(txt.Text);
CultureInfoculture=CultureInfo.CreateSpecificCulture("fr-FR");
txt.Text=text.ToString("N0",culture);
Do you have any idea ?
Madhanmohan Devarajan10y ago
Jim,
I think for your case, you can try implementing JQuery on keypress method. So that while the user types in the values in textbox commas will be placed in appropriate places.
Please try these below links
http://www.dotnetcurry.com/jquery/1076/using-jquery-add-commmas-numbers-textbox
http://stackoverflow.com/questions/2632359/can-jquery-add-commas-while-user-typing-numbers