Number formatting issue
 

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

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
EditPaste 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

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