Hi,
The following is a way to convert your old numbers. In an unused cell type
1.0%
Decrease the decimal place to 1 if required. Copy that cell and select all
of the values you wish to convert (Hold CTRL key down if required). Go to
Edit>Paste Special and choose Multiply. Click OK.
HTH,
Matt
"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
Bookmarks