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
amitash
0
Newbie Poster
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.