• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 295
  • Last Modified:

Reference number in excel

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
cansevin
Asked:
cansevin
2 Solutions
 
Saqib Husain, SyedEngineerCommented:
=TEXT(Z2,"#%")&"/"&TEXT(AA2,"#")
0
 
mcj2006Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now