Link to home
Start Free TrialLog in
Avatar of Bright01
Bright01Flag for United States of America

asked on

Fixing a embedded format

EE Pros,

I have a formula that embeds a % number.  How do I get it to recognize or suppress the % to reflect 2 decimal points?

Thank you in advance.

B.
Fix-for-embedded-percent.xls
Avatar of Shaun Vermaak
Shaun Vermaak
Flag of Australia image
=ROUND(0.666666666666667,2) & " %"

Open in new window

Avatar of Martin Liss
Martin Liss
Flag of United States of America image
What is the formula?
Avatar of Shaun Vermaak
Shaun Vermaak
Flag of Australia image
Or
=ROUND(A1,2) & " %"

Open in new window

if value in A1
SOLUTION
Avatar of Rgonzo1971
Rgonzo1971
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Shaun Vermaak
Shaun Vermaak
Flag of Australia image
Or
=ROUND(A1/A2 * 100,2) & " %"

Open in new window

where A1/A2 * 100 is some formula
Avatar of Bright01
Bright01
Flag of United States of America image

ASKER

Great job!  Rob nailed it; Rgonzo was a close second.  Thanks for working with a "crap" WB that I sent in by mistake.  Martin always catches my mistakes; generally I curse myself and send him back something that actually doesn't have password protection on or actually has the formula I'm looking at a fix for.  But you guys anticipated what I was looking for and produced the formula.

Much thanks,

B.