 |  |  |  |  |  |  |  |
Format Number
Please support our VB.NET advertiser: Intel Parallel Studio Home
 |
Hi All,
Hope I'm now at the right place. Well.... I have a numeric field and I want to format the field as follows in the select statement. How should I do it??
For eg.
9000 - 9,000
10000 - 10,000
120200 - 1,20,200
etc....
Simply an indian format. How is that possible?
Thanks in advance.
Hope I'm now at the right place. Well.... I have a numeric field and I want to format the field as follows in the select statement. How should I do it??
For eg.
9000 - 9,000
10000 - 10,000
120200 - 1,20,200
etc....
Simply an indian format. How is that possible?
Thanks in advance.
It seems that .NET does not support Indian formatting for some reason. You have to implement formatting yourself, for example write your own (overloaded) ToString method. Shouldn't be that hard to write code for this.
I did find a one .NET implementation for this (both numbers and dates Indian Number & Date format, but the source code is in C#.
I did find a one .NET implementation for this (both numbers and dates Indian Number & Date format, but the source code is in C#.
Teme64 @ Windows Developer Blog
•
•
•
•
Originally Posted by arunkish 
Hi All,
Hope I'm now at the right place. Well.... I have a numeric field and I want to format the field as follows in the select statement. How should I do it??
For eg.
9000 - 9,000
10000 - 10,000
120200 - 1,20,200
etc....
Simply an indian format. How is that possible?
Thanks in advance.
Format(yourNo, "#,##0")
all the best
Last edited by penguinruwan; Dec 16th, 2008 at 2:03 am.
Try this :
Go to Control Panel >>>> Regional Options >>> Numbers and change the "Digit Grouping" like 12,34,56,789 then OK
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Label1.Text = Format(Your No., "##,##0")
End Sub
Go to Control Panel >>>> Regional Options >>> Numbers and change the "Digit Grouping" like 12,34,56,789 then OK
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Label1.Text = Format(Your No., "##,##0")
End Sub
Last edited by sierrainfo; Dec 17th, 2008 at 8:32 am.
|
Similar Threads
- Format of the number (C)
- Currency format in Bash Script (Shell Scripting)
- Format Number in Sql Query (Visual Basic 4 / 5 / 6)
- XSLT to copy a specific number of nodes (XML, XSLT and XPATH)
- Format Number as percentage. (PHP)
- Need help with java string.format (prepayment calculation) (Java)
- Lining up number at the decimal. (C)
- .htaccess mod_rewrite problem (Linux Servers and Apache)
Other Threads in the VB.NET Forum
- Previous Thread: Data from datatable after datagrid sorting
- Next Thread: to stop window minimization automatically
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest VB.NET Posts
- Today's Posts
- Unanswered Threads
.net .net2008 30minutes 2005 2008 access account arithmetic array basic binary bing button buttons center check code combobox component connectionstring crystalreport data database databasesearch datagrid datagridview date design dissertation dissertations dropdownlist excel fade file-dialog filter folder ftp generatetags google hardcopy images input insert intel internet mobile monitor ms net networking objects output panel passingparameters peertopeervideostreaming picturebox picturebox1 port position print printing problem problemwithinstallation project save searchbox searchvb.net select serial shutdown soap survey table tcp temperature text textbox timer timespan toolbox trim update updown user vb vb.net vb.netcode vb.netformclosing()eventpictureboxmessagebox vb2008 vbnet view visual visualbasic visualbasic.net visualstudio visualstudio2008 web winforms wpf year
