<div>
<div class="content wysiwyg-content">
In column Z I have a list of numbers that are in the form of percents. In column AA I have a numbers that have no decimal place. In column AB I want to have the Column Z/Column AA.<br />
<br />
I used the following code: &nbsp; &nbsp; =Z2&amp;&quot;/&quot;&amp;AA2<br />
<br />
The result would look something like this: 11%/25. Instead I am getting the following:<br />
<br />
.107758620689655/24.874158<wbr />743<br />
<br />
How to I keep the numbers formatted like I want them?<br />
<br />
Thanks!
</div>
</div>


In column Z I have a list of numbers that are in the form of percents. In column AA I have a numbers that have no decimal place. In column AB I want to have the Column Z/Column AA.

I used the following code:     =Z2&"/"&AA2

The result would look something like this: 11%/25. Instead I am getting the following:

.107758620689655/24.874158743

How to I keep the numbers formatted like I want them?

Thanks!

Reference number in excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.