How to pick up a percentage in a formula?

[nhungtran]

Hello. I'm having some trouble with this formula. Can someone please help?

example:

cell B5 says -6%

formula
="aged debtors decreased by "&B5

ideally i would like the result to be "aged debtors decreased by -6%" but is coming up with "aged debtors decreased by -0.56988713816163"

any help is appreciated.

nhung

 

[FDibbins]

Maybe something like this?
="blah blah "&TEXT(B5,"0%")
Note that -0.56988713816163 is not 6%, it is 56%

 

[nhungtran]

Maybe something like this?
="blah blah "&TEXT(B5,"0%")
Note that -0.56988713816163 is not 6%, it is 56%

Thanks Ford. sorry i miss typed. -0.056988713816163

I tried your formula and it came back with 0. not -6%

 

[FDibbins]

Based on your sample data, see below...
[Table="width:, class:grid"][tr][td] [/td][td]

B​

[/td][td]

C​

[/td][td]

D​

[/td][/tr]
[tr][td]

5​

[/td][td]-0.056988714[/td][td]blah blah -6%[/td][td]blah blah -5.7%[/td][/tr]
[/table]
C2="blah blah "&TEXT(B5,"0%")
D2="blah blah "&TEXT(B5,"0.0%")

 

[nhungtran]

Based on your sample data, see below...
[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[TD]

D​

[/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]-0.056988714[/TD]
[TD]blah blah -6%[/TD]
[TD]blah blah -5.7%[/TD]
[/TR]
</tbody>[/TABLE]

C2="blah blah "&TEXT(B5,"0%")
D2="blah blah "&TEXT(B5,"0.0%")

Thank you! It didn't work the 1st time as i missed the " around the 0%

Appreciate your help!

Nhung

 

[FDibbins]

Happy to help