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%
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.
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).