add the percentage symbol without format

Question

add the percentage symbol without format

Hello,

Is there a way to "add the percentage symbol without formatting"?

I want to leave the integrity of my cell formula in place but display the result with a % symbol.

MacBook Air

Posted on May 17, 2016 2:15 AM

Reply

Answer 1

May 17, 2016 7:24 AM in response to Wayne Contello

I checked help first but it did not solve my issue. I didn't need help with my equation it was only with numbers formatting as described above.

I appreciate your help but please understand I am not a kiddy, I am a 50yr old man trying to study at University and learn a new computer system. I purchased this macbook air specifically for study but am still learning.

Your reply makes me wonder if I am really welcome to ask such a question on here again, I hope I am wrong.

Reply

Answer 2

May 17, 2016 4:07 AM in response to Yellowbox

Hi Thanks for your reply please see below screen shot.

The formula for the highlighted cells is Return on Total Assets = Net Profit before Interest & Tax / Average Total Assets x 100

I would like to maintain the formula by not using the inbuilt % function as it requires me to remove the x 100 from my formula. Average total Assets is not shown on that screen but it is in the formula.

Is there a way to just show the cell result for formatting the text to show the result with a % sign?

Reply

Answer 3

May 17, 2016 5:34 AM in response to Darrenfocused

you can use the concatenate operator to append the percent sign after the results of your formula.

change the formula:

Net Profit before Interest & Tax / Average Total Assets x 100

to

Net Profit before Interest & Tax / Average Total Assets x 100 & "%"

the "&" add one string to another string

Reply

Answer 4

Yellowbox

Level 7

21,939 points

May 17, 2016 3:59 AM in response to Darrenfocused

Hi Darren,

I want to leave the integrity of my cell formula in place but display the result with a % symbol.

What is the formula? What cells contribute to that formula?

A screen shot will help to explain.

Please reply with a screen shot of a small part of your screen (command shift 4 and drag). Full screen shots (command shift 3) are often difficult to read.

Please include the Formula Editor in the screen shot or paste the formula into a reply.

See this User Tip by Wayne on how to post a screen shot.

How to Post a screenshot to the Apple Discussion Forums

Regards,

Ian.

Reply

Answer 5

May 17, 2016 5:43 AM in response to Wayne Contello

Many thanks that is excellent but the next issue is formatting to appropriate decimal places.

I tried to change it using the "Format" button but it does not accept it, is there additional string to get appropriate decimal places please.

Many thanks for everyones help 🙂

Reply

Answer 6

May 17, 2016 7:21 AM in response to Darrenfocused

Darren,

In the future, better to disclose this is for homework. You should learn how to do this and learn how to use the help tools. Number has extensive help which we would have suggested first.

Everyone here is happy to assist but we don't do homework.

when you type the "=" (equal sign) in a cell, then Number function browser appears on the right. You can search for functions.

In addition, there is online help using the Numbers menu item "Help > Formulas and Functions Help"

Reply

Answer 7

May 17, 2016 7:31 AM in response to Darrenfocused

All I am saying is that disclosing this is a homework assignment is essential. We are always happy to assist, even with homework, it's just that we may guide more and provide less direct answers so as to preserve the learning experience.

Please do not take offense at my comment it is intended only to guide future posts.

Reply

Answer 8

Barry

Level 9

60,023 points

May 17, 2016 5:22 PM in response to Darrenfocused

Hi Darren,

I'm quite surprised that you are permitted (probably encouraged, and possibly required) to use a spreadsheet application to calculate a result, but that you would lose marks if you also used the application's ability to format that result as a percentage.

I doubt there are many current spreadsheet applications without the ability to display 0.2955 correctly as 29.55% by formatting the result as a percentage.

Regards,

Barry

Reply

Answer 9

May 17, 2016 6:55 AM in response to Darrenfocused

round(Net Profit before Interest & Tax / Average Total Assets x 100, 2) & "%"

Reply

Answer 10

t quinn

Level 5

7,063 points

May 17, 2016 7:04 AM in response to Darrenfocused

Hi Darren,

Just curious as to why preserving "x100" is important. Allowing the % format seems easier.

quinn

Reply

Answer 11

May 17, 2016 7:06 AM in response to t quinn

Its for an assignment where I need to show workings. If I leave out a part of the calculation, I will loose marks 🙂

Reply

Answer 12

May 17, 2016 7:13 AM in response to Wayne Contello

Wayne,

Many thanks for your help, that has finished my assignment perfectly, now just need to format and convert to PDF, (thats easy) and submit to Turnitin.

Many thanks again 😁

Reply