When trying the code below, my desired output is "8,000 dollars" but it shows up as "8000 dollars" without the comma. If I comment out the SetCellValue line, I do get "8,000". Am I doing this incorrectly? I want to maintain the numberformat and append text at the end.
I think there is not any way that you will get a format like 8,000 dollars, you may check it in MS Excel. I think you can use like $ 8,000 instead. Please refer to my previous code snippet.
Well 8,000 is just the format not the original number, the original value is 8000, so when you concatenate it with widgets it will become 8000 widgets. And I think this is same in MS Excel. Any how we will further look into it if we can make it and get back to you soon.