Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Reference number in excel

Posted on 2013-12-19
2
Medium Priority
?
286 Views
Last Modified: 2013-12-19
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!
0
Comment
Question by:cansevin
2 Comments
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 1000 total points
ID: 39729633
=TEXT(Z2,"#%")&"/"&TEXT(AA2,"#")
0
 
LVL 2

Assisted Solution

by:mcj2006
mcj2006 earned 1000 total points
ID: 39729659
I'm guessing that for cell AA is formatted to show 0 decimal places and is rounding to 25.
If that is the case you could change your code to
=TEXT(Z2,"#%")&"/"&ROUND(AA2,0)
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question