How to add thousands separator to string value which may contain floating points

Question

I have a string series of values which may or may not contain a floating point number. I want to add the thousands separator to this numeric string. I want to have the value with thousands separators and floating point number only when it's there. How can I do this?

Examples:

Input:  23456.78
Output: 23,456.78

Input:  23456
Output: 23,456

Dmitrii Bychenko · Accepted Answer · 2016-05-19 10:19:14Z

4

Try parsing to decimal (or double) and then format back to the required representation ("#,#.##########" format string in your case):

String input = "23456.78";

// 23,456.78
String output = decimal
 .Parse(input, CultureInfo.InvariantCulture)
 .ToString("#,#.##########", CultureInfo.InvariantCulture);

edited May 19, 2016 at 10:19

answered May 19, 2016 at 9:40

Dmitrii Bychenko

188k20 gold badges178 silver badges231 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Nishantha Maduranga Over a year ago

Thanks for the reply, The only problem with your answer is that when i try to input "5754289" and it returns "5754289.00". But i don't need the floating point part with it.

Dmitrii Bychenko Over a year ago

@Dinukshi Jayarathne: if you don't want .00 and alike floating point, then format string should be something like "#,#.##########" (see my edit)

Collectives™ on Stack Overflow

How to add thousands separator to string value which may contain floating points

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related