Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

add a comma for thousands place -- in a string

Posted on 2014-02-22
6
Medium Priority
?
292 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
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
LVL 86

Accepted Solution

by:
Mike Tomlinson earned 2000 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

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

In my previous two articles we discussed Binary Serialization (http://www.experts-exchange.com/A_4362.html) and XML Serialization (http://www.experts-exchange.com/A_4425.html). In this article we will try to know more about SOAP (Simple Object Acces…
It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Loops Section Overview

783 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