Double values

Help Something Else
, ,
1

hi i want to have output like this
“1,002,432,89”
how can i achieve this

image
image965×358 18.6 KB

this is my currently output
image

2

Hi @ldiaz

Can you share the Input

1 Like
3

@ldiaz

Check below post for your reference

Hope this may help you

Thanks

1 Like
4

HI @ldiaz

Checkout this steps

only difference is you need to give your format in the configure format wizard

Regards
Sudharsan

1 Like
5

may input value is from my data table
which is currentline 17 and currentline 30

6

Hello @ldiaz
Try this expression

CDbl(YourString).ToString("N", CultureInfo.InvariantCulture)

image

1 Like
7

HI @ldiaz

Just simple use like this

CDbl("123456789.85").ToString("n")

image

Regards
Gokul

1 Like
8

Hi @ldiaz

Try like this

Double.Parse("123489789.85").ToString("n0")

image

Regards
Sudharsan

1 Like
9

To round Of the value try this
CDbl(123463658.82).ToString(“N0”, CultureInfo.InvariantCulture)
image

10

Double.Parse(yourvalue).ToString(“#,0.####”)

11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.