Format in today

[tlindeman]

Here is my formula: ="Training Program Complete "&SUM(1-SUM(H31-TODAY())/100) which works great, the problem I am having is that I need the result to be in percentage and it is showing in whole numbers. (.03 instead of 3%). Changing the format of the cell to percentage does not change it.

Thank You
Tony

 

[Jonmo1]

Try

=TEXT(1-SUM(H31-TODAY())/100,"##%")

 

[tlindeman]

perfect thank you

 

[Ron Coderre]

Try something like this:

="Training Program Complete "&TEXT(1-(H31-TODAY())/100,"0.0%")

Does that help?