Function to format a value into percent with no decimal

K

Kurt Heisler

I have about 50 rows of data, each with 2 columns. The first column
(A) holds a number; the format is General. The second column (B)
divides the number in A over 51, using this formula =A1/51 (and
=A2/51, =A3/51, etc.). The format for column B is Percentage with 0
decimal places, so the results look like 25%, 4%, etc.

I'd like to create a third column (C) which concatenates the results
of columns A & B to yield something like:

13 (25%)

But instead I get:

13 (0.254901960784314)

The function I'm using is:

=B1 & " (" & C1 & ")"

I'm thinking I need to somehow enter syntax so the C value formats as
a Percent with 0 decimals places. Any idea how I can do this? The
final value of C can even be a string; I'm not doing any further
calculations with so I don't even need anything to stay in a numerical
format.
 
N

Niek Otten

=TEXT(B1,"0")& " (" & TEXT(C1,"0%") & ")"

Adjust the formatting of B1 to your needs
 

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

Reference a cell in a named range 1
Format a percent 7
Number decimal place 3
Format a percent field 1
Access stripping decimal places in query 1
Format a Percent 4
Automatically chnage number format of a range of cells 2
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2

Top