&Function

[larsvane]

Hi I am making an excel with some ranges in it. Bottom left, left, middle, richt, top right. And I want to show the full range with an & function. As shown below.

Bottom Left	Left	Middle	Right	Top Right	Range
2	4	6	8	10	2-10

In the "Range" column I am using an =A2&""&E2 function. This works fine when it is a regular number. However I also want to do this with percentages. The output is in decimals instead of percentages. Example below

Bottom Left	Left	Middle	Right	Top Right	Range
5%	7%	9%	11%	13%	Reality: 0,05-0,13 Want: 5%-13%

Is this possible with the & function or should I use a different kind?

Many thanks in advance!

 

[etaf]

use TEXT( cell, "%")

="reality "&TEXT(A2,"0.0%")&" to "&TEXT(B2,"0.0%")

text(A2,"0.0%")&""&text(E2,"0.0%")

Book20
	A	B	C	D
1
2	20%	70%		reality 20.0% to 70.0%
Sheet1

Cell Formulas
Range	Formula
D2	D2	="reality "&TEXT(A2,"0.0%")&" to "&TEXT(B2,"0.0%")

if you want to round the result - then just text(a2,"0%")

if you want the - inbetween then you need
text(A2,"0.0%")&" - "&text(E2,"0.0%")

rounds
text(A2,"0%")&" - "&text(E2,"0%")

Book20
	A	B	C	D	E	F
1						see it rounds down and up
2	20.4%	70.8%		20.4% - 70.8%		20% - 71%
Sheet1

Cell Formulas
Range	Formula
D2	D2	=TEXT(A2,"0.0%")&" - "&TEXT(B2,"0.0%")
F2	F2	=TEXT(A2,"0%")&" - "&TEXT(B2,"0%")