I am seeking help! Lol. I have the following, which I'm using to concatenate 2 cells into a text box. When the cell updates it also updates the txt box. However, the formatting is wrong when it concatenates the 2. B5 needs to be a number and C5 should be a percent. Does anyone know a quick solution for this?
Current example: B5=50, C5=10%
Answer = 500.10
What I would like it to look like:
Answer = 50 - 10%
Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzerPlease Login or Register to view this content.
Bookmarks