0

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.

4
Contributors
3
Replies
4
Views
8 Years
Discussion Span
Last Post by sierrainfo
0

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#.

0

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.

Try this
Format(yourNo, "#,##0")
all the best

0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.