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

percentage 7
EXCEL FORMULA 2
how do i combine a date cell and a time cell in excel? 3
help with formula 1
Help with formula 4
Substitute IF statement. 9
formula to display cell address 2
Auto Forward in Mailbox 4

Top