Formatting when combining text & value in a cell

  • Thread starter Thread starter John13
  • Start date Start date
J

John13

The value of my cell is

="Product Margin is "&Z5

Z5 is 63.6% (in Z5) but 0.63653676693 in my combined cell. How do I
format the percent when combining text & value? Thank you for your
time.
 
Thank you very much, works great. And thanks for the quick response.

John
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting, Icons 1
Extracting Month from Date and doing a calculation 8
Sum and multiply at the same time? 5
Subtotal question 4
Speed of Replace Range 6
handling links to external spreadsheets 2
Applying Formulae to a worksheet which are hidden 11
If formula with two conditions to meet 7

Back
Top