(Solved) – VBA: how to pass text in demanded format to different cell


I have:
Range(“A1”) = 0.0576877
Range(“A1”).NumberFormat = “0.0%”

Range(“A2”) = “Percentage of people: ” & Range(“A1”)

I want to have a following text in the cell “A2”: “Percentage of people: 5.8 %”

But I still got: “Percentage of people: 0.0576877”

I still cant find the right solution. I’m new to this, of course. Any ideas? Thank you guys!

Leave a Reply

Your email address will not be published. Required fields are marked *