Share via

format percent within a formula

Anonymous
2011-01-11T21:20:26+00:00

Hi! 

I am using a formula to populate column headers so measurement guidelines can be updated easily.

My chart heading reads:

="< "&c12

where C12 is 95% (and formatted to read exactly like this)

The cell, and subsequently the chart, populate with

< .95

I really prefer it to read:  < 95%. 

How can I do this without having to delete chart labels and reenter each time there is a change.

Thanks for your help.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2011-01-11T21:31:01+00:00

    Hi,

    Try the TEXT function which is aimed to format text :

    If Range A1 contains 0.12

    and if in Range A2, I enter the following formula =TEXT(A1;"00%") the result should be in cell A2 :  12%

    Hope this helps

    Regards

    F.

    70+ people found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest