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
Recommended Answers
Jump to PostSomething 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
C#Jaap
5
Junior Poster in Training
amitash
0
Newbie Poster
C#Jaap
5
Junior Poster in Training
QVeen72
104
Posting Shark
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.