convert String to Digit adding comma

[k3pineapple]

Hi Team,

wired case, need your help on adding comma in "string" number. Don't know wht's wrong here.

[abacon]

If you click the button in the screenshot, it will display the output with commas in the results window. Is the data not showing correctly in your output tools?

[alexnajm]

This works fine for me, and saves you the extra conversion step

[k3pineapple]

Hi Alex, the input is in V_String not digit, size 9999, try the same, still doesn't work. any work around?

[k3pineapple]

@abacon sry abacon, cannot open the attachment, would you mind post the pic directly in the post box? Many thx

[alexnajm]

That wasn't mentioned as an initial requirement... but ok then you need to convert it into an actual number before you do the ToString function

[alexnajm · Accepted solution]

You can save yourself a step even

[abacon · Accepted solution]

Sorry about that, not sure why it didn't take. Try this one.

[k3pineapple]

Find the answer which should use xlsx instead of csv data.