cell reference within text (decimal place)

[beelzebubble]

Hi,

This should be easy, but I can't seem to figure it out. I simply want to set the decimal place to 0 for a cell reference (which contains a numerical value based on a formulated calculation) within a block of text. Specifically, I've got the command below within cell F14.


="The percentage of people who said 'Yes' is equal to "&B15&"%."


It works fine, except that the cell reference value has way too many decimal places. That is, it produces the following:


The percentage of people who said 'Yes' is equal to 21.754152254656%.


I want it to produce:

The percentage of people who said 'Yes' is equal to 22%.


Thanks for any help

 

[Legacy 68668]

="The percentage of people who said 'Yes' is equal to "&Round(B15,0)&"%."
?

 

[T. Valko]

Is B15 formatted as Percentage?

Here's another one:

="The percentage of people who said 'Yes' is equal to "&TEXT(B15,"0%")

 

[beelzebubble]

Thanks (yet again), Seiya.

 

[beelzebubble]

Curiously, when I run the formula as a macro:

Range("Sheet4!F14") = "=The percentage of people who said Yes is " & Round(B14, 0) & "%."

it produces an error.

If I try

Range("Sheet4!F14") = "The percentage of people who said Yes is " & Round(B14, 0) & "%."

It produces:

'The percentage of people who said Yes is 0%?'

Is there something 'special' that must be specified when the text is a combination of text and cell reference/formula? I've tried Range("Sheet4!F14").Formula, but that didn't work, amongst other things.

Any ideas?

 

[Legacy 68668]

try

Range("Sheet4!F14").Formula = _
"=""The percentage of people who said Yes is""&Round(B14, 0)&""%.""

 

[beelzebubble]

That did the trick. Cheers, Seiya.

 

[Legacy 68668]

Oops, I think I missed one " at the end...