|Subject:||Re: Function to format a value into percent with no decimal|
|Posted by:||Niek Otten (nicola…@xs4all.nl)|
|Date:||Fri, 20 Mar 2009|
=TEXT(B1,"0")& " (" & TEXT(C1,"0%") & ")"
Adjust the formatting of B1 to your needs
Microsoft MVP - Excel
"Kurt Heisler" <HeislerKu…@gmail.com> wrote in message
>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
Function to format a value into percent with no decimal posted by Kurt Heisler on Fri, 20 Mar 2009