Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a group of numbers that already have a decimal in them. Example 68.77 when I try to format to make this a percentage I get this 6877%. How do I get it to keep the decimal in the number? I am looking for 68.77%

share|improve this question

Type 100 anywhere on the sheet and copy it.

Then select your numbers and hit paste special - divide

Now they can all be turned into the correct percentage.

share|improve this answer
    
Thank you- that worked! – Cmom Jul 25 '13 at 16:44
    
It seems to me that this would change the numeric to a text cell making it problematic to use in a later formula. – mdpc Jul 25 '13 at 16:58
    
@Cmom I completely altered my answer due to mdpc being correct in the above comment. Cmom - I would urge you to delete your "that worked" comment here and re-evaluate the answer. – Raystafarian Jul 25 '13 at 17:15

If you want to maintain the numeric cell format for use in later computations, I might generate another column using the formula something like =b1/100.0 for all the cells in the new column. This assumes your problem column is in B.

another suggestion, is that if this is derived from a formula, change the original formula to divide by 100 (or you could multiply by 0.01).

share|improve this answer

If you want to display the whole number simply with a "%" at the end, try this format from the Excel format menu, 'custom' formats: "0.0\%);(0.0\%);0.0\%);@%)"

Worked for me:

81.3582914270273 = 81.4%

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .