- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2009 March
- Re: Function to format a value into percent with no decimal

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

--

Kind regards,

Niek Otten

Microsoft MVP - Excel

"Kurt Heisler" <HeislerKuâ€¦@gmail.com> wrote in message

news:8ad6c00d-3300-405a-a288-1a8c8f6bb4â€¦@13g2000yql.googlegroups.com...

>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.

None

Function to format a value into percent with no decimal posted by Kurt Heisler on Fri, 20 Mar 2009