Hi, I want to change the numeric value in a cell to a string with 1000 Separator(,), e.g. numeric 1000 will to string "1,000" and 123456789 will change to string "123,456,789". How to do that in VBA? Thanks
Jump to Post
Something like this does change the representation in your worksheet.
Sub ChangeActiveCellFormat() ActiveCell.NumberFormat = "#,##0.00" End Sub
Depending on you local settings of Windows Excel uses a . or a , to separate the thousands.
This however converts the content of the active cell into text …
All 4 Replies
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.