Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

2 Answers 2

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.