Before copying in the new percentages try this on the old data:

Assume that the 'old percentages' are in column A and start on row 1. In B1
just type =A1/100, and drag that all the way down to the bottom of your 'old
percentages' list. Then, copy the data in column B and paste only the values
(right click - paste special - Values) into column A. Then format them as
percentages and it should work out.

- Dave


"Gayle" wrote:

I have table with extensive entries (which I inheriited) that are formatted
as general numbers (ie 92.1 or 10.6) when they really are percentages. I am
adding current data to them, but the cut and paste process brings the new
data correctly, as percentages. I have tried changing new entries to match
by dropping the percent sign, but that doesn't do it, and I have tried
changing the old data to percents, but it formats them incorrectlt (ie 71.6
becomes 7160%) I am not a mathmetician - and maybe there isn't any way to
work this out, but I am having to hand enter every number. Any help out
there??? Thanks