Skip navigation

Formatting to percentage from any other format problem

748 Views 10 Replies Latest reply: Jul 28, 2011 1:39 AM by KOENIG Yvan RSS
Quantum3 Level 1 Level 1 (0 points)
Currently Being Moderated
Jul 27, 2011 7:54 AM

Hi Folks,

 

I'm using Numbers and having a problem when formatting. For example, I have some cells which are formatted to $ or just numbers or whatever, and when I want to format those cells to %, the numbers which already existing on cells, changes drastically like from 15,89 to %1.589,54 instead %15,89.

 

Any solution for that?

 

Thanks in advance,

 

Ø3

MacPro Hapertown, Mac OS X (10.5.8), 8 cores
  • Level 8 Level 8 (41,760 points)

    Please, for two minutes, read carefully.

    For US readers, I answer using the asker's settings which means : use the decimal comma.

     

    15,89 % is the number 0,1589

    when you apply the percent format to the number 15,89 the application does exactly what you ask it to do and return 1589 % because 15,89 is 100 times 0,1589.

     

    Next time, take care to what you ask.

    Enter 0,1589 before applying the percent format and you will get 15,89%.

     

    It was a new proof that often, the problem isn't the application but the user.

     

    Yvan KOENIG (VALLAURIS, France) mercredi 27 juillet 2011 17:33:01

    iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.0


    Please : Search for questions similar to your own before submitting them to the community

     

    To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !

  • Wayne Contello Level 6 Level 6 (12,580 points)

    For the cells you know you want to show as a percent you can modify the formula to be divided by 100.  after you apply the "%" formatting it will look like you want.

     

    Indicentally... formatting as percent means taking the fraction of the number in the cell divided by a "whole" (or 1). this operation ends up multiplying the value in a cell by 100.

     

    Wayne

  • Barry Level 7 Level 7 (29,095 points)

    Quantum3 wrote:

    The problem is that the numbers in the cell are the result of an operation, so I cannot change the values as you mentioned by double clicking on the cell, so I have to apply the format on the cell and there is when the problems comes out.

    Then the real problem is that the operation returning those numbers is not calculating a percentage. Percent, literally translated from the Latin, means "per hundred".

     

    25% means 25 per hundred

     

    Written as a fraction, that's 25/100

     

    Written as a decimal, 0.25

     

    Written as a percent, 25%

     

    Regards,

    Barry

  • Level 8 Level 8 (41,760 points)

    Quantum3 wrote:

     

    (1) The problem, Koenig, is that the numbers in the cell are the result of an operation, so I cannot change the values as you mentioned by double clicking on the cell, so I have to apply the format on the cell and there is when the problems comes out.

     

    (2) Next time, most of us would appreciate if you left your ego aside in the process of replying.

    (1) I guessed that you were able to understand by yourself that it was necessary to insert a division by 100 in your formula.

    It appears that I was wrong.

     

    (2) Next time, I would appreciate (I can't speak for others) that you drop this kind of comment.

    As I already wrote several times, I write went I want, the way I want.

     

    Yvan KOENIG (VALLAURIS, France) mercredi 27 juillet 2011 21:02:29

     

    iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.0


    Please : Search for questions similar to your own before submitting them to the community

     

    To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !

  • Level 8 Level 8 (41,760 points)

    I'm really not interested by your opinion.

     

    I repeat :

    "I write went I want, the way I want."

     

    I'm really not really by your comments. Happily, life has an end !

     

    Yvan KOENIG (VALLAURIS, France) jeudi 28 juillet 2011 00:49:02

    iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.0


    Please : Search for questions similar to your own before submitting them to the community

     

    To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !

  • Level 8 Level 8 (41,760 points)

    I like my life but don't wish to finish resembling to some askers here. It means that I don't wish to finish as a vegetable.

     

    Yvan KOENIG (VALLAURIS, France) jeudi 28 juillet 2011 10:39:34

    iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.0

    My iDisk is : <http://public.me.com/koenigyvan>


    Please : Search for questions similar to your own before submitting them to the community

     

    To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.