Hi Team,
wired case, need your help on adding comma in "string" number. Don't know wht's wrong here.
You can save yourself a step even
Sorry about that, not sure why it didn't take. Try this one.
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?
This works fine for me, and saves you the extra conversion step
Hi Alex, the input is in V_String not digit, size 9999, try the same, still doesn't work. any work around?
@abacon sry abacon, cannot open the attachment, would you mind post the pic directly in the post box? Many thx
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
Find the answer which should use xlsx instead of csv data.