Combining a whole number and a % in one cell

J

Jimll565

I'm tryingto combine a whole # and a percentage in the same cell

A1= 25 B1= 78% C1=25 / 78%

I used =A&" / "&B1

What I get is C1=25 / 0.7794223

I think I need it to merge the product and not the formula.
 

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

Indenting every other paragraph in Word at the same time? 0
VBA Coding Help for Beginner 0
If, Or, and 5
Need help with IF statement (function) 1
Number range as a percentage 2
Looking to added up based on a character from cell range 1
EXCEL FORMULA 2
percentage 7

Top