Solved

add a comma for thousands place -- in a string

Posted on 2014-02-22
6
286 Views
Last Modified: 2014-02-27
I have this

Dim strNumber as string = 100000

msgbox(strNumber)

- the result i get is 100000

I want it to do this 100,000


How?
0
Comment
Question by:vbnetcoder
  • 3
  • 2
6 Comments
 
LVL 40
ID: 39879357
Ideally, since this is a numeric value, you should treat it as a number, not as a String:

Dim number As Integer = 100000

Where does your data comes from?

There are different ways to add the coma, depending on whether you get the data as a String or as an Integer, whether it is a fixed value as seems to be the case from your question, whether the value can change, whether you want to adjust the coma vs dot to the user's Control Panel.

What is your exact situation?
0
 

Author Comment

by:vbnetcoder
ID: 39879365
Actually to use your code to put a dollar space i would do this

number.tostring("C0")

In my case i don't want the dollar sign but i do want the comma.  How do i do that?  Basicly i need to replace "C0" with something else but not been able to find it.
0
 
LVL 40
ID: 39879416
With a number, you can use the following:

If you want to follow the Control Panel, which is the right way to do things in Windows for display purpose, use the following, using as many # and , necessary to apply to your biggest number:

Number.ToString("###,###")

This will show , on some computers, a space on others, depending on the Control Panel.

If you want to force a coma, which might be the case for a report or a text file, then force a display with the English conventions:

Number.ToString("###,###", New System.Globalization.CultureInfo("en"))
0
The New “Normal” in Modern Enterprise Operations

DevOps for the modern enterprise offers many benefits — increased agility, productivity, and more, but digital transformation isn’t easy, especially if you’re not addressing the right issues. Register for the webinar to dive into the “new normal” for enterprise modern ops.

 
LVL 85

Accepted Solution

by:
Mike Tomlinson earned 500 total points
ID: 39879448
"In my case i don't want the dollar sign but i do want the comma.  How do i do that?  Basicly i need to replace "C0" with something else but not been able to find it."

See "Standard Numeric Format Strings":
http://msdn.microsoft.com/en-us/library/dwhawy9k(v=vs.110).aspx

Use "N0" then:
        Dim number As Integer = 100000
        Dim strNumber As String = number.ToString("N0")

Open in new window


It will add the correct number of separators for you.
0
 

Author Closing Comment

by:vbnetcoder
ID: 39892951
ty
0
 
LVL 40
ID: 39893003
Note that "N0" follows the Control Panel. It might give a coma on your computer, but a space or another character on another computer.
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question